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! : )