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

 

Howto build Active Report with 2 Data Dropdown Lists triggering one DataDeck

Started by IceTea, 19 Mar 2015 01:49:42 PM

Previous topic - Next topic

IceTea

Hi all,

i'm facing a conceptional problem.

What we wanna have:

Active Report in which user can select Month & Organization Unit.

Based on this selection, one crosstab should be rendered with data based on the selected Month and selected Organization Unit.

While Organization Unit is some kind of filter based on the initial selection, Month is not. Because based on selected month we calculate previous months and so son (YTD... PY).

For now, what we did is one single DataDeck which has Level Month and Level Organization Units as Deck items.

The crosstab with report data content is inside of this DataDeck. It has separate Query with a Master-Detail-Relationship to the DataDeck Query.

This MDR links Query item for OrgUnit with the other Query item for OrgUnit. For month the Query item of DataDeck-Query links to a month-parameter, which is used to calculate in the crosstab query a member for the selected month ([Dim View].[Time].[Timedimension].[month] -> ?prm_monat?).

So far so good.

With filtered months and filteres Orgunits, the report calculates very fast (30s). While unfiltered months (4 years) and unfiltered Orgunits (13), report doesn't come back at the moment.

My question is:
Is this best practice to face our needs or do we make some big mistakes on our way?
How would you Design this Active Report ?