SAP Script in QV

[#1]

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

[#2 · Accepted solution]

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