Fact Table question

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

Moderator: Alex Zencovich

Fact Table question

Postby CM » Tue Sep 19, 2006 2:35 am

The more I use this product, the more I like it. Great job in your programming work. :)


I am currently using the PivotCube in a project involving time tracking and budgeting for projects, which are comprised of hierarchical "project items." Time slips recorded against these project items have, as you might expect, attributes such as hours, employee ID, date, activity item (also a treeview) etc. The PivotCube makes getting rolled-up time totals across the entire project MUCH simpler.

What I'm wondering is, is it possible to have, in addition to the rolled-up total ACTUAL hours showing up as a column (I have the treeview project items on the left as row headers, and the total actual hours as a column), the budgeted hours --- which are part of the project item table -- show up as a column as well? I'm not sure how to set up the fact table, which is based of time slips, to include that data (which is based on the project item) w/o compounding it... if that makes any sense.

I guess what I'm asking is A) is this possible to do with the PivotCube?, and B) any recommendations re: what to set as measures vs. dimensions, and fact table source, etc. to pull it off w/the PivotCube.


Thanks for any and all help! : )
CM
User
 
Posts: 7
Joined: Fri Sep 15, 2006 11:26 pm

Postby AlexZencovich » Tue Sep 19, 2006 5:40 am

As far I understood, you should to have hours (total and budgeted) as measures and other - as dimensions
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 2 guests

cron