SAP OLAP Connector

[Anonymous]

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.

[#2]

You rename the dimensions on Load *, where you pass the *, you define use the all dimensions the BW.

[Anonymous · Accepted solution]

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

[Anonymous]

Thank you!