cancel
Showing results for 
Search instead for 
Did you mean: 

0FISCPER converting the date

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Sri Harsha,

The display properties should be changed in the global settings. Also we can limit it to particular user also.

Former Member
0 Kudos

Venkat How can I do this? I cannot change the descriptions of the Object as I have privilages to only work on the report.

Is there something I can do on the report as I need to calculate based on the 0FISCPER values.

Answers (1)

Answers (1)

Former Member
0 Kudos

Got it solved!