Making OLAP connection using Custom Data Source

[manpreet.singh]

Hi,

I have a custom data source which is made as per the steps on http://community.jaspersoft.com/wiki/custom-data-source-sample-readme This custom data souce makes web service calls which returns JSON data. The custom data source converts JSON data to the JAVA objects. So far things are good. But now I would like to create OLAP view based on this custom data source. Has anyone tried this sort of thing in past and has some documentation around it?

Thanks
Manpreet.

[pssp25]

Hi Manpreet,

For OLAP you need

• the connection "MySQL, MSSQL or whatever your DB
  the schema.xml file with the cube definition of you OLAP cubes.
  Connection connection = DriverManager.getConnection("Provider=mondrian;Jdbc=jdbc:mysql://localhost/databasename?user=root;password=;Catalog=file:c:/temp/schema.xml;JdbcDrivers=com.mysql.jdbc.Driver;" , null);
• Need to use MDX queries 
• Create a JSON from the mondrian result.

Let me know if this helps you?

Kind regards,
Paulo