Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have connected to SAP BW by the SAP OLAP Connector. How do I rename the dimensions in the script? It's not taking aliases (as).
Please help.
You need to modify the Load statement (comes after the preceding Select statement), for example:
[$0FIAP_C03]:
Load
[<Dimension Alias Name returned by OLAP Connector>] as [Company Code],
*
;
Select PseudoMDX D ( ....
... ;
Cheers
Yaniv
You rename the dimensions on Load *, where you pass the *, you define use the all dimensions the BW.
You need to modify the Load statement (comes after the preceding Select statement), for example:
[$0FIAP_C03]:
Load
[<Dimension Alias Name returned by OLAP Connector>] as [Company Code],
*
;
Select PseudoMDX D ( ....
... ;
Cheers
Yaniv
Thank you!