No Drill Through Option With Issue Dimension In Columns

[Андрей Зонин]

If Issue dimension is for table rows I have an option "drill through" to browse related issues. When I transpone the table and Issue dimension becomes a column feature, this option evades. 

Transponing is preferable as most members are in Measures dimension and vertical alignment fits the screen best. 

How to transpone and have "drill through" available?

[eazyBI Support · Accepted solution]

Hi Andrei,

Drill through issues option works only when "Issue" dimension is used in rows or not used for the report at all.

Drill through issue.jpg

When "Issue" dimension is used in columns, drill through option is not available like you already discovered.

Perhaps you could try using issue level from "Issue" dimension when it is used in columns.

Issue in columns.jpg

Please share your business case to support@eazybi.com if you have further questions regarding this!

Kind regards,

Martins Vanags / support@eazybi.com

[Андрей Зонин]

There is one more "drill-through" difficulty.

On an empty report we add Issue dimension as rows and Issue type dimension as columns. We have one cell of totals we can "drill through".

Now we switch off the Totals in selected members of Issue and add a calculated member with an identical formula: "[Issue].[Totals]". In this case visually everything is the same, but we can't drill through.

How to keep this option available?