Skip to Content
0
Former Member
Mar 24, 2009 at 01:57 PM

Security hierarchy and Presentation hierarchy

46 Views

Hi,

I am using a security hierarchy with a hidden variable on 0PROFIT_CTR in filters and presentation hierarchy on ZPROF_CTR in rows. As the variable is hidden when the user runs the report he wont see the hierarchy variable in the variable screen. The output gets restricted to whatever the user has security to but as I am using a display hierarchy it shows me at the highest level even though the output values are right.

Eg: USER1 has access to PC1.And say PC1 falls under node PC2 which falls under node PC3.

When the USER1 runs the report the values are restricted to PC1 but as I am using a display hierarchy it shows me PC3( and then drill to PC2 and PC1). Is there anyway I can just show PC1.

Thanks,

Kal

P.S. The presentation hierarchy is derived from security hierarchy.