Palo Odbc Demo

Dear visitor, welcome to Palo Community Forum. If this is your first visit here, please read the Help. It explains in detail how this page works. To use all features of this page, you should consider registering. Please use the registration form, to register here or read more information about the registration process. If you are already registered, please login here.

peter10_14

Professional

Posts: 20

Date of registration: Oct 26th 2007

Friday, February 27th 2009, 10:21am

Palo Odbc Demo

Dear all!

I found on PALO Website a Online-Demo with ODBC conection. I can drill down form OLAP Report to the data entry.

How will that be realized? I use a mssql database and palo. What i do actually is to generate a textfile via ms access to use the importfunction of palo.

With this methode it won't work to generate a drill down function.

Thanks

This post has been edited 1 times, last edit by "peter10_14" (Feb 27th 2009, 2:34pm)

Go to the top of the page

cuboo

Master

Posts: 62

Date of registration: Sep 30th 2008

Friday, February 27th 2009, 6:25pm

RE: Palo Odbc Demo

Hi,

I think you have to extract the data with the jedox ETL-Server to realize a Drill-through!

Lars

Go to the top of the page

dominik_l

Jedox Team

Posts: 348

Date of registration: May 7th 2008

Location: Freiburg / Germany

Saturday, February 28th 2009, 3:24pm

In this demo, the data is fetched directly from MySQL by the Worksheet-Server, so this demo isn't connected to the drilldown function of ETL.

However, to do a drilldown in Excel from Palo data cells to (more detailed) source data (like MySQL), you need the non-free Palo Supervision-Server. The ETL Server is one system that can function as a source for drill through, but with Supervision-Server, drillthrough to other sources is possible as well.