COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: collierd on 31 Jul 2009 12:13:01 PM

Title: Conditional Format Security
Post by: collierd on 31 Jul 2009 12:13:01 PM
Hello

I have 2 costs, one standard, one standard plus 5%
I want to show one set of users the standard cost and another set the cost plus 5%

Potentially, I could do this on two reports

If I wanted to do this on one report, what's the best way

Here's the catch:

Currently, I have Active Directory groups
A way to do this with 2 reports would be to use 2 AD groups and grant visbility dependant upon your group
OR use the AD group and some conditional formatting

Problem is, our base ERP system holds the relevant flags for security

Given that I have an account id and I have a flag to say which cost I should use, how do I use that flag - I have nothing to join on
The flag is user specific and I don't want to join from anything, I just want to say if the flag is 1 show actual cost and if it is 0 show cost plus 5%

Any advice would be appreciated

Thanks
Title: Re: Conditional Format Security
Post by: uttam.mistry on 31 Jul 2009 03:09:45 PM
you can use session parameters/variables/parameter map for this depending on that flag is available,...

like if AD can provide you that flag, you can use macro functions with session parameters...
if that flag is available as a windows session variable you can use macro functions with session variable... (anyone please correct me if I am wrong)

or you need to create a parameter map for this flag with key as username and value as a flag...

in report or in Model itself you can create data item as
if(#_based on what u r using_flag__# = 1)
then (cost)
else (cost*1.05)

refer FM user guide -> macros / ->session parameters / ->parameter maps

hope this helps!!!!