Unable to create global variant for BEx query

[former_member566830]

Good Day BI Experts.

I would like to be able to provide some of my power users with the ability to create global variants to BEx queries executed using Analyzer. When they try to save a global variant now, they receive the message "You are not authorized to create variant name". Is there a generic role that can be assigned to the user for this? Or perhaps a PFCG setting to an existing role? I'm rather new at this, so details would be appreciated.

Thanks.

Casey

[Former Member · Accepted solution]

Hi.

Your users need to have create and change access for auth object S_RS_PARAM to create variants.

You can enforce a naming convention by maintaining the values of "tech name of variant" like Z*, according to your needs.

Regards

Jacob

P.S:

If you have a general role for report users, add the auth object to that one in PFCG if it's not already there. In the latter case, you might have to change the values, to let your users maitain things...

Edited by: Jacob Jansen on Jan 27, 2010 7:10 PM

[former_member566830 · Accepted solution]

Jacob / Michael,

Thanks for you quick replies. Adding the authorization object got me what I needed, and the table reference helped me track it down. I have awarded points to each of you.

Thanks.

[michael_devine]

Hi,

When you create a variant in BEx Analyzer for NW2004s, the variant is always created as 'User variant', that means only the owner will be able to access these variants. It is not possible to create 'Global variants' with NW2004s.

However this is available in BI Web applications for NW2004s, these variants are always saved as 'Global variants'. So these variants are visible to all users. They are stored in table SE16 -> RSRPARAMETRIZA.

I hope this at least a little bit helpful.

Michael