Reg. Non Additive fact table design

FAQ

Profile

Reg. Non Additive fact table design

Database Forums (Home) -> Data Warehouse

Next: New Record not appearing in Table

Author

Message

sarnee

External

Since: Jan 29, 2008
Posts: 1

(Msg. 1) Posted: Tue Jan 29, 2008 8:37 pm Post subject: Reg. Non Additive fact table design Archived from groups: microsoft>public>sqlserver>datawarehouse (more info?)

I have to design a non additive fact table. The following is the hierarchy Project -> SubProj ->Plan -> Phase -> WorkFlow Now I will be calcurating measures like EV,SV and LF All the Metrics are non-Additive and i have to use the formula to calculate the data in each level. How can i design my Fact table so that i will be able to get the metrics value at all the levels from the same table. Thanks, Saran >> Stay informed about: Reg. Non Additive fact table design

Display posts from previous:

Related Topics:

Fact Table design question - Can a degenerate dimension act a a primary key in a fact table when a composite of the foreign keys (linking to dimensions) doesnt form a unique key?...The fact's granularity is at the line level and aggregating is not an option... example. service..

Fact Table(s) Design Question - Please forgive the cross-posting, I wasn't sure the best place to put this question. I'm modeling a procurement process as part of a data warehouse project - and in this case what we're procuring is people (filling jobs). The basic process is that the..

Fact Table Design for Hours Worked - Hi, I am trying to design a cube with Date, Time and Employee dimension which can answer following questions: - how many employees were working at 10am on 15 June 2007? I - how many man hours were pais between 10am -11am on 15 June 2007. If somebody..

FACT table design problem--banking domain - Our customer is from foreign exchange department of the bank. Because they never have a DW project experience before, they don't know their requirement. We collect their OLTP system snapshots to understand their business and what columns on the screen..

Fact Table Design Question - Monthly Tracking of Employees - Hello All, I've read Kimball's chapter on HR Data and I think I get it, but I am still a bit confused. I need to track data on a monthly basis. In each month I need the start and end headcount. I use two fields, Active Begin Month and Active End..

	Database Forums (Home) -> Data Warehouse	All times are: Pacific Time (US & Canada)
Page 1 of 1

You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum