I'm working with Pyramid Analytics for some time now and there is a hidden feature that's kind a handy when creating many bioXL files. In the bioXL ribbon there is a possibility to set another default query model.

The default model will put the first dimension on rows, second dimension on columns and first measure in subsets. Consider changes this query model based on your preferences.
Available models:
|
First dimension will be the first hierachy (if available) from the first dimension based on text sorting
Time dimension will be the dimension with time intelligence attached
Measure will be the first created measure in the cube
Personally i prefer the fifth option. Measure on columns vs time on rows.
Geen opmerkingen:
Een reactie posten