on 11-02-2017 2:55 PM
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
I will appreciate any help
Thank you
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.