04-23-2012 11:39 AM
I am working on reports based on a IMAP for a cube.
One of my objective is to produce automated PDF reports (using rptbatch).
If I create a basic report with one dimension (rows) and a measure, then the report initially shows only the first level of the hierarchy.
Now for my reports I need to show the whole drilldown.
I noticed that when I develop a level in WRS consultation, next batch generation takes that into account (retains the drilldown)
However, I need a way to automatically details all levels (go until last level of hierarchy) as members will change over each cube update.
I didn't find any way in WRS to specify that I want my hierarchy fully developed automatically.
Any way to manipulate the WRS with code?