If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Conditional Format Security

Started by collierd, 31 Jul 2009 12:13:01 PM

Previous topic - Next topic

collierd

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

uttam.mistry

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!!!!