Pyramid Analytics - bioXL - Default values for rows & columns

Creating bioXL files is easy. Within a few minutes you've created a new report and you can start with the next one.

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.

First, lets navigate to the hidden feature. Create a new bioXL, navigate to the "Query" tab and click on the "User options" icon. In this menu you probably will find other options that might be useful. I will discuss these in another post



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:

Columns First dimension Rows Second dimension Subsets Measure Columns Time dimension Rows First dimension Subsets Measure Columns Time dimension Rows Measure Subsets - Columns First dimension Rows Time dimension Subsets Measure Columns Measure Rows Time dimension Subsets -

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.