Hello all
In dimensional reporting coming from cube, requirement is to show 2 levels.
Say hierarchy is:
Market > Region > State(Source - State Name,Category Code - State Code)
So user requirement is to show in drill down: Market then Region and then in next level State Name and State Code in two columns together.
Output:
1st Level:
Market | Count
When clicked on Market,
2nd Level:
Region | Count
When clicked on Region,
3rd Level:
State Name | State Code | Count
Is this possible in Report Studio and how?
Also, is it possible to put 2 measures in slicer as filter and what if we put measure in detailed filter, it is giving correct result?
Thanks
Can anyone please help with the issue?
The drill-down functionality is going to drill down the hierarchy on a single column as defined in your dimension. If you want the state code and name to appear on a level, you will have to define the caption to include them but they will appear as one column. There is no way to have one drill-down automatically split into two columns.
Alternatively you could define your own drill-through reports, rather than using built-in drill-up/down. In that case, the target reports can obviously be formatted however you like.