SAP Script in QV

Tue, 27 Sep 2011 11:36:01 GMT

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));

Re: SAP Script in QV

Tue, 27 Sep 2011 11:46:18 GMT

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));

topic Re: SAP Script in QV in QlikView

SAP Script in QV

Re: SAP Script in QV