Hi,
I'm developing a report based on DMR model. Geography(Region and Country are the levels) and Time are the 2 dimensions which I'm using to create a report.
I have a prompt in my report,(text box prompt). I created a dataitem with the calculation that says, if the value entered is R then show Region else show Country.
In the report, I have taken Time as the Columns and Dataitem as the rows in the crosstab .
Based on the prompt selected, Region/country is displayed, but the drill up/down function is not shown up for datatitem.
Is it that, if we define any calculations and use them in the crosstab, drill up/down functionality will not work?
Please help ???
By default, the report will NOT have drill-down/up functionality turned on... You will need to enable this.
In the Data menu, Select Drill Behavior.
I have selected that option from Data menu. Still drill up/down is not wrkg on the calculated item that I have created... :(
Hi,
The issue is that you are using a query calculation, thereby removing the prederermined hierarchical structure from your rows area. Even if you define this as a member set and change the drill down behaviour to "replace expression", there will still be nowhere to drill down or up to that the report understands.
If I had to write a report like this, I'd probably try one of the following:
a) Use a Tree prompt instead of a value prompt (ie in your query calculation, use an expression such as [Your geography hierarchy] -> ?Geogparam?)
or b)
Create two crosstabs, one with the Region level in the rows, the other with the Country level in the rows, then use a conditional block to render one or the other dependent on your prompt.
Good luck!
MF.