Pyramid Report building basics

Pyramid reports are based on SSAS cubes, which means we have measures and dimensions.

If you have used Excel to show SSAS cube data, then it will be easy to understand Pyramid reports to show SSAS cube data.

To start with in columns go the measure(s) and on rows go the dimensions.

If your requirement needs to have even one or more dimensions in columns then you can do that too.

Pyramid provides slicers, in addition to rows and columns. You can have additional dimensions in slices too. They are just like SSRS report parameters.

Pyramid has parameters in addition to slicers.

Above as i mentioned if you want an dimension in both slicer as well as in row ( or column) we need to create it as an parameter.

We need to create parameters if we want a dimension in both slicer as well as row/column. When we create parameter, just remember to give it different name, since we can’t call it the same thing. We can change the actual caption text to make it more meaningful and user friendly.

Pyramid provides sub-sets for filtering.

Pyramid report has the cube name and any additional info about its structure.

If you want cascading slicers, you have to go to ribbon Query=> in advanced section select cascading prompt and then based on your requirement select single or multi hierarchy.

Let’s say you selected multi. Now it opens up the cascading prompt wizard. Add the dimensions you want to do cascading with. Once finished the related dimensions will be added to slicers in BLUE.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s