0FISCPER converting the date
hi all!
I have a BEx Query, displaying the Fiscal Period and Amount for a particular Account during a period (Both Account and Period are optional during selection)
My display values are 0FISCPER and Amount in LC (0DEB_CRE_LC)
When I execute the report I get output as
Period 001/ 2001
period 008/2001
September etc.
The Cube has
2001001
2001008 values for 0FISCPER
and I need the out put as it is in the cube(2007010,2008005,...)
How can this be done?
I tried changing the display property for 0FISCPER as Key only from Text. still it gives me a (/) in middle how can I remove it?
Help appreciated.
Regards,
Sri Harsha