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.
PivotCube and more than one fact dataset
Moderator: Alex Zencovich
2 posts
• Page 1 of 1
PivotCube and more than one fact dataset
by dominikh@pascom.pl » Thu Nov 30, 2006 10:10 am
Dominik Haska
- dominikh@pascom.pl
- Guest
- Posts: 2
- Joined: Tue Nov 21, 2006 7:08 am
- Location: Poland
by 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.
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
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
2 posts
• Page 1 of 1
Who is online
Users browsing this forum: No registered users and 3 guests