Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
When I load in data from SAP bw, Im given this query in my QV script.
Is there anyway I can manipulate this data? When I try to change the name of any dimension, im given an error.
For instance, if I try to change the '[0CUSTOMER] (),' line to '[0CUSTOMER] () as Cust,' - im given an error.
Is there a way in which I can change this code? thanks
Select PseudoMDX (
Dimensions (
[0CUSTOMER] (),
[0CUST_GROUP] (),
[0MATERIAL] (),
[0MATL_GROUP] (),
[0SALES_DIST] (),
[0SALES_OFF] (),
[ZPAPH1] (),
[ZPAPH2] (),
[ZPAPH3] (),
[ZPAPH4] (),
[ZPAPH5] (),
[0CALMONTH2] (),
[0CALYEAR] (),
[0FISCPER] (),
[0FISCPER3] (),
[0FISCYEAR] (),
[0REQUID] ()),
Measures (
[00O2TGJNNG8HFWTUF0XMET37G].[00O2TGJNNG8HFWTUF0XMETFUK], //GP
[00O2TGJNNG8HFWTUF0XMET37G].[00O2TGJNNG8HFWTUF0XMET9J0], //GP%
[00O2TGJNNG8HFWTUF0XMET37G].[00O2TGJNNG8HFWTUF0XMETSHO], //Revenue
[00O2TGJNNG8HFWTUF0XMET37G].[00O2TGJNNG8HFWTUF0XMETYT8]), //Sales quantity
From (ZM_FI_01/ZM_FI_01_Q002));
With "Preceding Load" ;
LOAD * , [0CUSTOMER] as Cust ;
Select PseudoMDX (
Dimensions (
[0CUSTOMER] (),
[0CUST_GROUP] (),
[0MATERIAL] (),
[0MATL_GROUP] (),
[0SALES_DIST] (),
[0SALES_OFF] (),
[ZPAPH1] (),
[ZPAPH2] (),
[ZPAPH3] (),
[ZPAPH4] (),
[ZPAPH5] (),
[0CALMONTH2] (),
[0CALYEAR] (),
[0FISCPER] (),
[0FISCPER3] (),
[0FISCYEAR] (),
[0REQUID] ()),
Measures (
[00O2TGJNNG8HFWTUF0XMET37G].[00O2TGJNNG8HFWTUF0XMETFUK], //GP
[00O2TGJNNG8HFWTUF0XMET37G].[00O2TGJNNG8HFWTUF0XMET9J0], //GP%
[00O2TGJNNG8HFWTUF0XMET37G].[00O2TGJNNG8HFWTUF0XMETSHO], //Revenue
[00O2TGJNNG8HFWTUF0XMET37G].[00O2TGJNNG8HFWTUF0XMETYT8]), //Sales quantity
From (ZM_FI_01/ZM_FI_01_Q002));
BR
With "Preceding Load" ;
LOAD * , [0CUSTOMER] as Cust ;
Select PseudoMDX (
Dimensions (
[0CUSTOMER] (),
[0CUST_GROUP] (),
[0MATERIAL] (),
[0MATL_GROUP] (),
[0SALES_DIST] (),
[0SALES_OFF] (),
[ZPAPH1] (),
[ZPAPH2] (),
[ZPAPH3] (),
[ZPAPH4] (),
[ZPAPH5] (),
[0CALMONTH2] (),
[0CALYEAR] (),
[0FISCPER] (),
[0FISCPER3] (),
[0FISCYEAR] (),
[0REQUID] ()),
Measures (
[00O2TGJNNG8HFWTUF0XMET37G].[00O2TGJNNG8HFWTUF0XMETFUK], //GP
[00O2TGJNNG8HFWTUF0XMET37G].[00O2TGJNNG8HFWTUF0XMET9J0], //GP%
[00O2TGJNNG8HFWTUF0XMET37G].[00O2TGJNNG8HFWTUF0XMETSHO], //Revenue
[00O2TGJNNG8HFWTUF0XMET37G].[00O2TGJNNG8HFWTUF0XMETYT8]), //Sales quantity
From (ZM_FI_01/ZM_FI_01_Q002));
BR