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).
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:
[<Dimension Alias Name returned by OLAP Connector>] as [Company Code],
Select PseudoMDX D ( ....
Retrieving data ...