1. Open The Qlikview Software, to build a new file, saved as test.qvw
2. Here I choose OLE DB try to connect Jedox, I choose Jedox ODBO Provider, click Next
Here I use the Bike_ETL sample of Jedox
3. It Pop out the window to entre all the connection information for Jedox. Test Connection, shows “Connection Succesfull”
4But I can’t see any table to choose
P.S Here all the server is turned on include JedoxSuiteMDXInterpreter
II. The script in Qlikview
I also write the MDX query in Qlikview script as follows:
SELECT{[Products].[DesktopL],[Regions].[France],[Months].[Jan],[Years].[2012],[Datatype].[Acutal]} ON ROWS, {[Measures].[Gross Profit]} ON COLUMNS FROM [orders];
And I run the Reload button in Qlikiew
After the Run the Reload, there is no error message Pop out:
Here is the result show no tabke or field in the system.
I would like to know if there is anyone who knows the how to extract the data from a cube for Qlikview? Normally, the MDX query works in SSAS, and as Jedox's official respond that Jedox generally follows all the protocols for MDX