getting problem in keyfigure values while extracting data from FF

[Former Member]

Hi,

I am extracting the data from FF.

My key figure values are like 657890, 3456270...

But after extracting the data am getting the values in cube like 657.890,00 and 3.456.270,00etc.

Please any one help me why i am getting dots and commas..

Thanks in advance.

[Former Member]

(from Menu bar) System > UserProfile > Own data > defaults > in decimal notation drop down choose appropriate format - log off n login

-kiran

[Former Member]

Thank you All.

My problem Solved.

Regards,

Subbu.

[Pravender]

In SU01/SU01d tcode check what is maintained in default tab --> Decimal Notation.. For you i think its maintained Y.. to see data in proper format change it to X (if you have access).

[Former Member]

Hi,

I checked in SU01. I defaults tab previously my decimal separator format is like 1.234.567,89

I changed it to 1,234,567.89. But still i am getting the problem.

Please help me.

Thank you,

Subbu.

[Former Member]

Hi,

I checked in SU01. I defaults tab previously my decimal separator format is like 1.234.567,89. Not Y...

There is no option to change it into X..

Please help me.

Thank you,

Subbu.

[Pravender]

I meant to change the format to 1,234,567.89

[Former Member]

Hi

There should be an option for "Decimal Notation", when you go through menu entry "System"->"User Profile"->"Own Data"->tab:"Defaults".

Set it to what you need.

Log out. Log in.

That should work.

regards

jacob

Edited by: Jacob Jansen on Oct 12, 2009 11:52 AM

[Former Member]

Hi,

Goto SU01 -> Defaults tab -> Decimal notation -> Change that to 1,234,567.89

You might have to log out and relogin for this to reflect correctly.

Regards,

Saurabh

[Former Member]

Hi,

Sorry to disturb you.

If i change like that i am getting the value like 62,253,000.

But my actual value is 622530.

I am getting 2 zeroes extra.

Any solution for this....

Thank you.

[Pravender]

Is it a currency field? If yes, whst is the currecncy for the value?

[Former Member]

Yes it is Currency field.

The currency value is NGN (fixed).

Thank you.

[Former Member]

Hi SubbuSiri,

There is no issue with the data extraction.This is just the way you have maintained your user profile.

Check your profile settings in su01d, in defaults tab. You can maintain the decimal notations the way you want to see.

Regards,

Pratap Sone

[Former Member]

Hi,

The representation of the data should not be a problem as this is not changing value of the data.

In your case, you have comma as the decimal separater and dot as the thousand separater. In case you want to change this setting you can set it up for the user by changing the default settings in SU01.

Hope this helps!

Regards,

Saurabh