If you are unable to create a new account, please email support@bspsoftware.com

 

How can I filter a ReportStudio report (from a cube) on a dimensional range?

Started by JGirl, 07 Sep 2006 01:54:52 AM

Previous topic - Next topic

JGirl

I have a report studio report from a cube.

The report contains a crosstab, showing measures by Org Structure dimension.

My cube contains a time dimension with a year level and a month level.

I want to accept two parameters (the prompts are built from the month level data item) from the user, the first month (parm_first_month) and last month (parm_last_month).

I then want to add a detail filter to the report that filters on [Month Level] between parm_first_month and parm_last_month.

How can I do this, remembering that I'm not using a database source (so I cant use in_range, >= and <=, between etc).  ie. How can i do this using the OLAP functions?

J

krogovin

Hi JGirl,

Try using tree prompts and sets in your report.

On your prompt page, drag in a tree prompt and pick the level (top or middle or in between) that you want to filter.  If you are displaying the object in the report, then make the parameter parmeterized.  Once you've built the prompt, go to your query.  Drag in a slicer member set into the slicer.  Here's the syntax:

set(object->?prompt?)

Also, to avoid printing lines without values, each row and column should be filtered with tuples.  Here's the syntax for that:

filter(object,tuple(revenue)<>0)

This strategy works well for crosstab trend reports.

hth