Question:
Hi ,
We have one requirement at the quey level.
We are actually populating the data into one key figure at the infoobject level as 1's and 0's (Zeroes) but the same 1's and 0's in those Key figures needs to be displayed as Y/N in the query output.
(The key figure properties are maintained as Integer )
If key figure is having a value as 1 then needs to be shown as Y in the query output.
If the key figure is having a value as 0 then it needs to be displayed as N at the query level.
How to achieve the above at the query level.
Please let me know asap if anyone knows it.
Thanks in advance
Jeevan
Answer:
I just reviewed the Query Designer. I can't see a way of transforming the Key Figure into Y/N based on the formulas that are available.
I was also thinking that perhaps a virtual key figure however if the key figure is typed as an integer I don't think it will allow an alpha value. Perhaps a virtual characteristic who's value is determined by your key figure.
Or, since you are not using the key figure for math and really want Y/N values have your design reflect the requirement and make it a characteristic. If you are getting passed 1 and 0 you can transform those values during the load into Y or N, or have text associated with the characteristic so you can display Y or N, or if you really only need Y/N have the data passed to you that way.