Traditional web-based reporting with SAS BI tools

OLAP based table fully deployed

Reply
Occasional Contributor
Posts: 9

OLAP based table fully deployed

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 idea?

Any way to manipulate the WRS with code?

Kind regards,


Eric

Post a Question
Discussion Stats
  • 0 replies
  • 167 views
  • 0 likes
  • 1 in conversation