Hi everybody,
I designed a query which contains in Rows a authorization relevant hierarchy named VENDOR and below that a character named APPLICATION with a character variable APP_VAR:
-- (hierarchy) VENDOR | -- (character) APPLICATION | -- (char. variable) APP_VAR
The rows are marked as "Display as hierarchy" so that APPLICATION is shown also as hierarchy.
A typical display is e.g.:
ROOT | -- VENDOR Group A result A | | | -- APPLICATION 1 figure 1 | -- APPLICATION 3 figure 3 | -- APPLICATION 4 figure 4 | -- VENDOR Group B result B | -- APPLICATION 1 figure 1 -- APPLICATION 2 figure 2 -- ...
Do you have any idea how I could allow or disallow to drilldown APPLICATION for a special user for VENDOR Group B so that it looks like:
ROOT | -- VENDOR Group A result A | -- VENDOR Group B result B | -- APPLICATION 1 figure 1 -- APPLICATION 2 figure 2 -- ...
Thanks in advance for your help,
Marcus.