on 09-29-2008 7:33 AM
Hi All,
We have queries in which a scaling factor of 1 Crore is applied. Query is developed in 7.0 and front end used for analysis is 3.x.
Is there any way to make the scaling factor a user entry field..like a variable entry ?
Please let me know if you have any pointers.
Thanks in Advance,
Amrita
For this you need not use the properties in Query.
You can create a formula variable and make it user entry.
You can create a formula for the keyfigrue and multiply by this formula variable.
This will have the same effect as scaling factor.
Hope this helps.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
I am not sure if you can make it a User Entry Variable or not.
Yes, the user can set the scaling factor. He needs to select the Key figure where he wants the Scaling Factor.
For 3.x front-end
Rt click on Key Figure --> Enhanced Menu --> Properties.
here, he will find the scaling factor.
For 7.0 front-end
Rt click on Key Figure --> Properties --> Data Cell --> Number Format.
here, he will find the scaling factor.
Hope this solves your problem.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.