on 04-05-2006 1:54 PM
We are trying to reverse a key figure sign and have got two options:
1. In Update Rule by using formula to make this key figure * 1-, or
2. In key figure property of query design mode, there is a checkbox of "Reverse +/- Signs".
Which one is better for the above two options?
Thanks
Message was edited by: Kevin Smith
Hi,
Using this property in Qurey level for that particular Query only....
again that depends on Requirements also...all users may not want to have this...so in this case do it in Query level..
If all users need this option,the do it in update rules.
Thnaks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
This depends upon how you are using them for reporting. From my eperience I suggest you to do this in Query. You can even use new formula for this. i hope this iwll help you.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
1. In Update Rule by using formula to make this key figure * 1-, or
A: If you want to update data permanently in Data Targets then go for update rules.
2. In key figure property of query design mode, there is a checkbox of "Reverse +/- Signs".
A: The data is not updated in Data Targets but while displaying in Reports it will display the sign.
That is upto you and business requirements.
Thanks
REddy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Option 2 leads to more time consumption at query execution than option 1 , enethough it is insignificant.
With rgds,
Anil Kumar Sharma .P
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
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.