Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Qlikview connect to Jedox

  1. 1. Open The Qlikview Software, to build a new file, saved as test.qvw

01.jpg

  1. 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


02.jpg

  1. 3. It Pop out the window to entre  all the connection information for Jedox. Test Connection, shows “Connection Succesfull”

03.jpg

4But I can’t see any table to choose

04.jpg

  1. P.S Here all the server is turned on include JedoxSuiteMDXInterpreter

05.jpg

  1. 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

06.jpg

After the Run the Reload, there is no error message Pop out:

07.jpg

Here is the result show no tabke or field in the system.

08.jpg

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

Is there anyone can figure out this problem?

Many thanks

Best regards

Yan