Display date at Key Figure

[Former Member]

Hello Dear SAP Gurus ,

I am facing a problem and need your help.

I have two problems with Key figures .

First one :

I created a key figure like :

DATE 

DATS

but when I try to save date at Planning Book , it is saving like number instead date .

for eg.

If I imput date  20140701 it will be saved as 20.140.701 and not 2014.07.01

Second One :

How to display any value without point.

For eg.: I need to display number 1201 and not 1.201

Hope someone help me ...

My best regards

Mauricio

[KodandaPani_KV · Accepted solution]

Hi,

1.instead creating the KF create the char with data type DATS then test it.

you want perform the calculation on the date field at reporting use the replacement path scenario while converting char to KF.

I need to display number 1201 and not 1.201

2. its showing reporting or cube level data?

if cube level showing create the test query on cube test in report.

Thanks,

Phani.