cancel
Showing results for 
Search instead for 
Did you mean: 

User entry for Scaling factor

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

former_member205352
Active Contributor
0 Kudos

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.

Answers (1)

Answers (1)

Former Member
0 Kudos

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.