Excel ODBO connection to cubes with different measures

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.

molap

Professional

Posts: 16

Date of registration: Mar 1st 2010

Thursday, April 12th 2012, 9:47am

Excel ODBO connection to cubes with different measures

Dear all,

we are using Palo 3.1 CE and have several cubes in our database. Some of these cubes have one measure and some of these cubes have two measures. Now, we are trying to connect to this Palo database via Excel ODBO (Pivot tables and diagrams).

Is it necessary that all these cubes use a common dimension named "Measures" although the cubes differ in the number of measures? Or is it possible to define two measure dimensions with different names and elements?