Question about how to recover a query characteristic
I have joined to the 'fiscal year/period' characteristic, of a bi query, from visual composer. I get the values for that characteristic but, I don't know why I see the values thus:
Period 00 2004
Period 01 2004
If I go to BEX the values for this characteristic are as follows:
Can any body tell me why I see different tha values between both tools?
Thanks in advance.
Vineeth k replied
I guess u have a query where you have 0fiscper in ur input selection.
You can try to create an input help using the wizard for this and it will guide you through the steps.
You will need to choose whether you need data from dimension/master data tables and finally the values to be displayed
(key/text/ext_key) in the value help table for fiscper . Since you are using a mandatory variable you would
need to use ext_key as your key field . Hope this was what you were referring to.