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