topic SAP OLAP Connector in QlikView

SAP OLAP Connector

Anonymous — Mon, 26 Jan 2026 21:26:37 GMT

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.

Tue, 15 Sep 2015 20:31:46 GMT

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

Anonymous — Wed, 16 Sep 2015 03:22:30 GMT

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 — Wed, 16 Sep 2015 17:19:32 GMT

Thank you!