Dimensional Reporting 2 Levels in Drill Down

[pram.b]

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

[pram.b]

Can anyone please help with the issue?

[bdbits]

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.