Script that connects OLAP-cube from qlikview - Page 2 - Qlik Community

Report Inappropriate Content · ‎2013-11-11

Hi All,

Please..

Can anyone suggest me the script to connect to OLAP cube.. I found below.. but m confused with name qualifier...that is bolded.

CubeData:

LOAD `[Measures].[Qty]` as Qty, `[Items].[Product].[Product].[MEMBER_CAPTION]` as Product;

SQL SELECT * FROM OpenQuery(LINKED_OLAP,'SELECT {[Measures].[Qty] } ON COLUMNS, { [Items].[Product].Members} ON ROWS FROM [CUBENAME]');

Regards,

Prajna

Report Inappropriate Content · ‎2014-02-06

Perhaps NAVdiscovery (QlikView Toolbox for Dynamics NAV) can help you with your problems: