cancel
Showing results for 
Search instead for 
Did you mean: 

Few variables missing from Input screen workbook

sravan_kampalli
Explorer
0 Kudos

Hello,

We are having one query for which we have created 10 variables, when user is running this query he is getting just 6 Variables on input screen remaining 4 are not appearing on screen, I checked Personalized setting also , nothing is personalized.

User is running query from Favorites and I am using BW 3.0 version

When other users are executing the same query they can see all variables. Could you please guide me how to resolve this?



Thank you


Accepted Solutions (0)

Answers (5)

Answers (5)

rajdeep_singh
Participant
0 Kudos

Hi Sravan,

Please send screen shot of variable sequence from Query properties.

Also what was the Output when you created a new query; di that help.

Thanks & Regards,

RDS

rajdeep_singh
Participant
0 Kudos

Hi Sravan,

Please try to see  Query properties --> variable sequence; how many variables are present over there.

If possible try creating a test query with the same variables do you still get the same output.

Thanks & Regards,

RDS

sravan_kampalli
Explorer
0 Kudos

Yes still it is missing after the refresh of the workbook.

every 2 nd time when i refresh the workbook the selection given to variables are missing they are not personalized.

Former Member
0 Kudos

Hi Sravan,

Pls check whether all the 10 variables are input ready/default values. I am suspecting that some of the variables are not ready for input and will be calculating in back end, depends on the input variable values. Pls check all the 10 variable properties.

Best Regards

Venkat...

sravan_kampalli
Explorer
0 Kudos

Hello,

here is the attached screenshot properties of variable.

Former Member
0 Kudos

Check all 10 variable definitions not only one.



Best Regards

Venkat...

sravan_kampalli
Explorer
0 Kudos

its same with all the 10 variables

former_member194898
Active Contributor
0 Kudos

Hi,

I would check it from authorizations' viewpoint.

Try to run the query using RSECADMIN first as the first user then as the second.

Regards, Leszek 

sravan_kampalli
Explorer
0 Kudos

Hello,

I see that issue with  my ID also.

I think its not related to authorization

RamanKorrapati
Active Contributor
0 Kudos

thru RSRT, try to regenerate your report and check it later.

Have you tried to run from your end, it showed 6 or 10 variables?

At dev system check it. if its shows 10 variables then you can retransport your query and work book to prod system.

sravan_kampalli
Explorer
0 Kudos

same with the dev systems also.it shows me 10 variables and then after selections again refreshed the workbook  the selected varibale is missing.

RamanKorrapati
Active Contributor
0 Kudos

please check your varaibles definaitons and authorisations as well.

is this is new query/workbook or old one?