Date formate Issue with key figure

[Former Member]

Hi gurus,

     I am working on BI 7.20. Issue described in this link ( http://scn.sap.com/thread/1738739 ) happens with me also but didnt get solution.

     I have a key figure as well as a characteristic which is mapped to same field of table. it is working fine in RSRT. But in Analyser, it is not. any idea??

Date in table	0CALDAY	ZKF_DATE
12.04.2013	12.04.2013	04.12.2013
13.04.2013	13.04.2013	13.04.2013

[Former Member · Accepted solution]

tried upto above GUI and patch level and it is worked for me. thanks prashanthji.

[Former Member]

Yes as suman said, it seems to be basic definition of custom field not in query?.

[Former Member]

@prashanthji :

  HI Prashanthji,

     current patch is 0. let me try >=14 patch level . thanks for reply.

@sumanji :

     Hi Sumanji..obviously data type must be DATS date field (yyyymmdd) internally stored. thanks for reply.

[former_member182470]

What is your Keyfigure "data type"? Is it date  or something else?

[Former Member]

is there any upgradation required ??? I am currently working on below version in Excel 2010.

[former_member182516]

Hi Renish,

what is the Patch you are using? You can check using the GUI.

Can you tell what is the latest patch u have on your system. If its lower try to apply pathc 14 or higher and check...

Regards

KP