1 Replies Last post: Nov 13, 2009 12:27 PM by gbhattachan  
gbhattachan Newbie 4 posts since
Nov 10, 2009
Currently Being Moderated

Nov 12, 2009 3:28 PM

What is the rational behind limiting report dimension to just two?

Is it performance? I would like to know why can't we add more dimensions(at least upto 3) as needed similar to "measures". The reason for this question: I have 100 reports that are already using secondary dimension as well, and I need to group these reports by, say regions or market group. And I certainly don't want to create 100 reports for each market group as that will multiply 100 x number of market groups( will grow as we move along..)

 

My existing report architecture:

-----------------------------------------------

+ BusinessAccountID-111

     - company nameA

     - company nameB

 

+ BusinessAccountID-123

     - company nameA

     - company nameB

 

Now, I want to track above information by regions or market group such as follows:

 

New report if I can have third dimension as well:

---------------------------------------------------------------------

+ European Retail Market

     + BusinessAccountID-111

          - company nameA

          - company nameB

     + BusinessAccountID-121

          - company nameA

          - company nameB

+ North American Wholesale Market

     + BusinessAccountID-123

          - company nameA

          - company nameB

 

And I want to keep market group data at the top of the dimension hirearchy, but due to limiting dimension to two, and are being already occupied by the existing data; I can't add market group information w/o concatenating BusinessAccountID and company name,  and then making concatenated value  as secondary dimension.

 

Because of this my only option is to concatenate BusinessAccountID and Company name and then use this as secondary dimension as shown below:

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

+ European Retail Market

        BusinessAccountID-111 :  company nameA

        BusinessAccountID-111 :  company nameB

        BusinessAccountID-121:   company nameA

        BusinessAccountID-121:   company nameB 

+ North American Wholesale Market

      BusinessAccountID-123: company nameA

      BusinessAccountID-123: company nameB

 

Am I missing anything here? Does anyone have any thoughts or suggestions ? Thanks in advance for your input.

More Like This

  • Retrieving data ...