PivotCube and more than one fact dataset

Discussion forum for PivotCube VCL users. Common questions. Bug and problem reports

Moderator: Alex Zencovich

PivotCube and more than one fact dataset

Postby dominikh@pascom.pl » Thu Nov 30, 2006 10:10 am

Hi!

Is there a possibility to connect cube to more than one fact dataset? I would like to show two totally independent fact datasets with the same dimensions, but other measures.
Dominik Haska
dominikh@pascom.pl
Guest
 
Posts: 2
Joined: Tue Nov 21, 2006 7:08 am
Location: Poland

Postby AlexZencovich » Thu Nov 30, 2006 12:47 pm

There are no way to have 2 different measure sets in same cube. It will two different cubes. Probably you may use SQL JOIN clause to combine two different datasources into single dataset

But if you want to load into cube data from 2 different facttables, sequentually you can do that.
Best regards,

Alex Zencovich
-------------------------------------------------------------------------------------------------------------------------------------------
www.pivotcube.com - OLAP solution for Delphi, C++ Builder and ActiveX environment
AlexZencovich
Site Admin
 
Posts: 580
Joined: Sun Jun 18, 2006 10:09 am


Return to PivotCube VCL

Who is online

Users browsing this forum: No registered users and 9 guests

cron