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.
We can extend dimension to third or four and so on, of course, performance penalty, by using "customer drill down dimension". It worked perfectly for me. Earlier, my thoughts stuck on custom Report configuration, where we add primary and secondary dimension to collect data out of log file, but later on I found out custom drilldown dimension is the way to go.
In new Dimension configuration:
- select "Custom Drilldown"
- then move available dimension to the left window to include as drilldown dimensions. That is it.
Report arranges data like this:
+primary dimension data
+ secondary dimension data
- tertiary dimension data