Skip to Content
avatar image
Former Member

MDX - set prtecision for a KPI

Hi everybody,

I have a query like this:

SELECT
NON EMPTY CROSSJOIN({
[00O2TJZ4GCWEXFU0VX4EWSO2I].[00O2TJZ4GCWEXFU0VX4EWC5WA],
[00O2TJZ4GCWEXFU0VX4EWSO2I].[00O2TJZ4GCWEXFU0VX4EWRFTM],
[00O2TJZ4GCWEXFU0VX4EWSO2I].[00O2TJZ4GCWEXH2TH3MTO5QE3],
...

...

}, {[Zxxxxx].[LEVEL01].Members})

ON ROWS

,

NON EMPTY CROSSJOIN({[0CALMONTH2].LEVELS(01).MEMBERS},{
[00O2TJZ4GCWEXFU0VX4EWSHQY].[00O2TJZ4GCWEXFU0VX4EWBGM2] ,
[00O2TJZ4GCWEXFU0VX4EWSHQY].[00O2TJZ4GCWEXFU0VX4EWBAAI] ,
...

...
[00O2TJZ4GCWEXFU0VX4EWSHQY].[00O2TJZ4GCWEXFU0VX4EWBMXM]
})

ON COLUMNS

FROM [compositeProviderName/QueryName]

SAP VARIABLES [0S_PLANT] INCLUDING [0PLANT].[plantName]
[ZGSCK_MONTH_RANGE] INCLUDING [0CALMONTH2].[MonthNumber]
[ZGSC_V_CYEAR1] INCLUDING [0CALYEAR].[yearNumber]

In the structure used by the query for the KeyFigure:

[00O2TJZ4GCWEXFU0VX4EWSO2I].[00O2TJZ4GCWEXH2TH3MTO5QE3] is set 2 decimals precision. Is there any way to set, for the MDX result, a bigger decimal precision.

I have seen the FORMAT_STRING function and that I can but I wasn't able to do it. I have written something like this:

WITH MEMBER oPH.x AS [00O2TJZ4GCWEXFU0VX4EWSO2I].[00O2TJZ4GCWEXH2TH3MTO5QE3], FORMAT_STRING='#.000'

SELECT
NON EMPTY CROSSJOIN({
[00O2TJZ4GCWEXFU0VX4EWSO2I].[00O2TJZ4GCWEXFU0VX4EWC5WA],
[00O2TJZ4GCWEXFU0VX4EWSO2I].[00O2TJZ4GCWEXFU0VX4EWRFTM],
[00O2TJZ4GCWEXFU0VX4EWSO2I].[00O2TJZ4GCWEXH2TH3MTO5QE3],
[MEASURES].[oPH.x],

.....

and I get no syntax errors but it sais Dimension oPH unkown . "oPH" is an invented alias

Is what I'm trying to do possible ?

THANKS in advance

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Nov 03, 2017 at 11:36 AM

    I will appreciate any help

    Thank you

    Add comment
    10|10000 characters needed characters exceeded