Skip to Content
0
Aug 04, 2005 at 01:56 PM

Allow and disallow drilldowns for different users

19 Views

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.