Skip to Content

values saved with different scale in infocube

Hello all,

I have to extract values from the cube into a spreadsheet and thereby I have experienced that some values which were saved in specific currencies (Loc_currency) are saved with an different scale then in the query. The values were entered with an BI planning query. e.g. in the query it is defines * 1000 IDR and the user enters 100, so I expect that in the cube the value is stored like 100000, but instead the value is stored as 10000.

This happens only for some specific currencies.

In the queries all values are displayed correct, just the way how those values are stored in the cube is not traceable. I have just noticed this, because I want to extract date out of the cube in an spreadsheet.

Is there any other logic for saving key figures with specific currencies sometimes?

The release is 7.1 and any hint for understanding this would be great.

Best regards,

Stefan from Munich/Germany

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Sep 04, 2009 at 09:54 PM

    Hi Stefan,

    Have you checked the table TCURX (also available via SPRO)?

    This table stores the number of decimal places that should be associated with a particular currency and basically applies a multiplication or division based on the values stored. Its default setting is 2 decimal places for each currency, so only exceptions to this need to be maintained. Examples include the Japanese Yen and the Korean Won where it doesn't make sense to have any decimal places.

    The settings in the table alter the way the data is updated to the InfoCube and also how the values are displayed by the queries.

    The following post may be of further help.

    [tcurx]

    Regards,

    Nick

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.