Can Selective access be applied in case of Dependent filter and list has not been considered in dimension?
@pranali08
Yes, but it depends on the level within the hierarchy the selective access is applied as to how you set up the line items.
In the line item formatting there are following options;
Only apply the selective access check at the level that is restricted.
For example;
L1
L2
L3 - selective access is applied
If we apply the selective access check to L1 and L2 line items then it will the drop down will be empty. Only select dependent so that the subsequent selections are filtered to only show the child items of the previous selection.
Apply dependent and selective access to L3 line item to ensure the dependency and the selective access filter out invalid options.
Thanks !
It's now possible to use the additional insights to have dynamic filters, however the columns in the table are fixed widths. It's quite unfortunate that the ability is added, but the layout isn't dynamic. I understand that a report is more fixed, but adding dynamic columns would really help make the management report…
There was an error rendering this rich post.
A quick reminder of the Bulk Copy functionality. Bulk Copy allows you copy large volumes of data from one slice of a model to another in a single, optimised operation, instead of using formulas or imports. Use case: copy a version (RF1) into a prior year version (PY RF1) using a versions list to allow for year-on-year…
