Question:
Hello BW Experts,
I was wondering if there is a way to create a keyfigure with 4 decimal places. like 123.4567
Any suggestions appreciated.
Thanks,
_________________
kcb2
Answer:
On the key figure change screen, under the Additional Properties tab, you can define the number of decimal places that will be visible when the query is run in BEx.
Answer:
But no use if there are no more then 3.
You can check it in the same screen, Additional Properties, in the details of the data element /BIC/"your object". Double click on it.
If changes are allowed (without developer key), you can use an other domain (SHIFT+F11). Use F4 and then "all selection". Fill in data type and 4 for decimal places. Maybe DEC5_4.
If changes not allowed create a new KF.
Answer:
Thanks Guest,
my requirement is a little additional. I have to read the number with 4 decimal places and store them and display. Any suggestions how to read and store..
Thanks,
Answer:
guest was me, kcb2
i was not logged in while posting
_________________
kcb2
Answer:
Thanks HVA.
Actually i tried you suggestion. To change the current keyfigure it asks for a develper key. But for the new one if I double click on the /bic/..
it says it still does not exist. So I can only double click it after I activate the infobject. So seems like the developer key is required. Is that rite.?
Thanks,
_________________
kcb2
Answer:
You could try setting the Data Type for your Key Figure to Floating Point.
I've never tried this myself but it appears that you can have 4+ decimal places.
Answer:
Just tried. Steps:
- create KF. Type: Number. Data type: DEC - etc..
- activate
- double click on data-element
- in Change mode (CTRL+F1)
- pop-up message: changes allowed
- cursor on domain (default RSKYFNUM)
- Change subobject icon or SHIFT+F11
- I used DEC5_4
- activate
That's it. I tried as attr. for masterdata object and works fine.
Answer:
This solution works fine for me in dev. However, when I try to transport the infoObject, the domain and the InfoObject make it into the target system separately, but the domain for the data element gets reset to RSKYFNUM. I am using a customized domain ZDEC11_6. How can I transport the modified domain along with the info object???
I am working on BW3.0 with PI 2003_1 and SP 13.
Answer:
Hello hva,
Did you ever figure out how to transport the changes to the test system?
I am in the same situation where the key figure is transported to the test system with the original domain attached to the data element, and not the new domain with the 3+ decimals.
I can possibly open the test system and make the changes directly in the test system. I would prefer not to do that if there is another way.
Any suggestions would be greatly appreciated.
Thanks in advance for your help!
ATC