Is it possible to have a different layout for the drill-through and main dataview?
We want to filter the drill-through based on a specific block so we want to create a filter block. We want the drill-through to hide rows where the Fiscal YTD is zero, and we want the main dataview to filter where WS P&L Filter is zero. Is it possible to have a different layout for the drill-through and main dataview? We tried to change the drill-through layout but the configuration does not get saved.
Answers
-
it seems you are confused between Drill-Down and Drill-Through which are two different functionalities.
The former is based on a Board Layout which can be different from the main dataview's layout. You just have to use the Drill and edit the layout it in design mode, it will create a pre-defined drill path that users can use through Drill-Down in Play Mode. Users can still use the Drill To Anywhere which will not inherited the layout defined for the Drill-Down.
On the other side a Drill-Through is based on a SQL query.
0 -
Hi Christian,
yes, it is possible to do it.
You should go in Edit mode, click on Drill anywhere and then on the window that appears you could edit the layout.
By closing it and saving the screen, you will obtain the customized screen when drilling down on the main dataview.
In the customized screen, you can add whatever you want, even the filter you are referring to.Note: please pay attention that Drill Down and Drill Through are two different functionalities.
Valentina
0 -
for Drill down, drill anywhere it is possible, as described by Valentina.
for Drill Through it is not possible because it is not defined in Board but in SQL. If you want to integrate a filter here you need to do it in the SQL Statement.
Fabian
1 -
User should to be able to drill down based on the layout we have configured for the drill down, currently only one entity at a time can be used with the configuration we want. If we select a different entity, the drill down configuration does not carry over. Furthermore, the configuration goes away after a drill anywhere. We want to be able to configure data view based on drill down via entity selection, and have the ability to apply the configuration to all entities as required.
0 -
Hi Christian,
It's possible to configure a drill to a separate screen, which might work well in your case. See this article for more info:
Thanks,
Anastasia
1 -
Hi Christian, yes it is possible either from design mode or play mode
However, to have the layout saved, you need to be in design mode and of course have the right license to be able to go in Design mode of the screen.0 -
For those reading and needing more information on creating a drill through, more information can be found here:
0
