cancel
Showing results for 
Search instead for 
Did you mean: 

How to remove some variables on startup when running workbooks in BI7

Former Member
0 Kudos

Hi BW Gurus,

We are on BI Version 7.1

Its a query on BEx Workbooks.

Specifically we have a number of queries within the workbooks.

We want to remove some of the input ready variables in these queries from displaying in the variables screen on a global basis so that all users do not see the variables.

I have looked at personalizing variables but this is on a user basis.

Also I am looking into variants but this would still display the input ready variables.

Is there any way to just stop these "non required" variables from appearing on a global basis without modifying the underlying queries?

Thanks in advance,

Stevo;)

Accepted Solutions (1)

Accepted Solutions (1)

hai_murali_here
Advisor
Advisor
0 Kudos

Hi,

If you wish to not showing the variables in the variable screen,then Personalize it.

And Hide showing these personalized variables in the variable screen.This you can acheive through

Variable screen->Settings->Move the variables which you do not want to show into Personalized variables and uncheck the checkbox "Show Personalized variables in the variable screen"->Click OK.This will not show the personalized variables in the variable screen.

Then create a gloabl variant for this settings.This global variant will be visible for all the user.

If you want to make it visible for only few users who log in,then create it as a Local variant.

Here you no need to change anything in the query.

Rgds,

Murali

Answers (5)

Answers (5)

Former Member
0 Kudos

Thanks Murali Points awarded

Former Member
0 Kudos

Hi Stevo,

Were you able to add some entries directly into the Personalization ODS? We have a certain requirement similar to the one you had and was wondering how you got around it.

Would appreciate any input in this regards.

Many Thanks.

Vivek

Former Member
0 Kudos

Hi Again.

Yes I can see this now thankyou again.

What we must achieve though is to remove some of the input ready variables in these queries in the workbook from displaying every time the variables screen is displayed on a global basis so that all users do not see the "not required" variables at all.

Is this not possible?

If not? Would the only option be to create new copies of the queries with some of the input ready variables removed.

We need to hide some of the input ready variables from all users on a global basis...

FYI we cant use personalisation as this is user based. Nor can we assign "persponalisation" to a variant as this is not possible/rechecks the box to display variable values.

Needs to be GLOBAL for all users and keep the "not required variables" hidden.

Could copy queries removing the not required variables but seems long winded?

Best

Stevo

Edited by: bw4eva999 on Nov 25, 2009 12:37 PM

hai_murali_here
Advisor
0 Kudos

Hi Stevo,

You want to show few variables for few users and avoid showing unnecessary variables to all the users.

You can create a variant specific to users and in that variant whichever variables is not needed for that particular user,you can set the default values for that variable(so that the user no need to bother to fill the values) and leave the values(leave it as blank) for other variables which the user will select and fill it.

This way we are making the user to avoid bothering about other variables which he doesn't want to select values(because we already set some default values in it) and only offer him to select the values for the variables which he want to select(since we left the values as blank for the variable which user wants,he has to select the values for that).

Here the user will see all the variables(even unnecessary variables),but select the values for the variables which he required.

I think this is the only possible way and don't know how to hide unnecessary variables for other users.Other than this,the only way is to remove it from query.

Rgds,

Murali

Former Member
0 Kudos

HI Murali,

Im looking into adding some new records in the Personalisation ODS that copy the personalisation required for a number of users that we choose.

Could then allow you to copy personalisation records for a number of users?

Really dont know if this will work but looking into it.

Best,

Stevo

hai_murali_here
Advisor
0 Kudos

Hi Stevo,

You can try this.

Wish your efforts work for you!

Rgds,

Murali

Former Member
0 Kudos

HI Murali, Thankyou.

We are saving these variants in a BEx Workbook with multiple queries within it.

We do not have the option "Save as User Variant" (BI 7.)

I have managed to "personalise the variables" to show just the variables we are interested in and unticked the "show personalized variables in variable screen"

Also I have saved this as a variant.

However when I reload the variant it shows the all the variables as the "show personalized variables in variable screen" is now ticked.

I.e when you save the variant it is unchecked but after reloading the variant it is checked.

Any ideas?

Kind regards and thankyou for your time.

Stevo

hai_murali_here
Advisor
0 Kudos

Hi,

Variable Personalization is not specific to a Variant.Its specific to the variable screen on that instance.So though you save the variant with the setting do not show personlaized variables,it won't get saved for that variant.If you invoke the variable screen again and observe the setting for the same variant,it will be like show personlaized variables checked.

Eventhough this looks weird behavior,this is how it works.

You can refer this link

http://help.sap.com/saphelp_nw70/helpdata/EN/45/6e4f4db9cc1956e10000000a11466f/frameset.htm

Rgds,

Murali

Former Member
0 Kudos

Hi MuraliKrishnan,

I have managed to create the "personalized variables" as you stated. However I cannot create a variant.

For some reason I click on the button to "Save as New Variant" and it does not do anything? No pop up screen or anything.

Would you or anyone know the reason for this please?

Also If i get round this and manage to save the variant do you have to write abap to change the variant from user based to global based in table RSRPARAMETRIZA that holds the BI Variants in BI 7.0???

Please advise.

Thanks for your time.

Kind regards,

Stevo.

hai_murali_here
Advisor
0 Kudos

Dear Stevo,

In the Variable Screen,You mention the variable values first and then click "Save as New Variant".

This will invoke the "Create New Variant",wherein you mention the Description and Tech name.Checking "Save as User variant" will allow you to create a Local Variant.If you uncheck this checkbox and create a variant means,it would be a global variant(Visisble for all the users in that system).

If "Create new variant" dialog doesn't pops up on clicking Save as New Variant,then it should be a problem with the build you have.Please update the latest Front End Patch available in SMP which is Front End Patch 1001.

Rgds,

Murali

former_member213877
Contributor
0 Kudos

Dear Stevo,

What will be the use of the variables if don't want any users to see the non required variables on the variable screen?

-Pradnya