on 04-10-2015 1:09 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.