Qlik Community

QlikView Connectors

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
chandni90
New Contributor III

SAP OLAP Connector

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.

SAP_BW.png

1 Solution

Accepted Solutions
yfe
Contributor III

Re: SAP OLAP Connector

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

3 Replies
Not applicable

Re: SAP OLAP Connector

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

yfe
Contributor III

Re: SAP OLAP Connector

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

chandni90
New Contributor III

Re: SAP OLAP Connector

Thank you!

Community Browser