Rapidly Changing Dimensions
Page 1 of 1 • Share •
Rapidly Changing Dimensions
Hi All,
I got an issue with rapidly changing dimension.
I am explaining a scenario.
In a company XX, Customer creates Projects(A project contains products) when he buys some thing from XX. The system internally creates orders for each project and the tickets are generated for each order. Tickets contain all the sale information, quantity, whose delivering the product.
Our client is requesting the drill down from Customer->Project->Order->Ticket.
I considered Order and ticket as degenerate dimensions as they grow in size along with fact table, but I thought this wont satisfy the above requirement because for drill across we need to have order and tickets as stand alone dimensions.
I snowflaked customer and project to achieve drill down from Customer->Project. I was struck here and from here I dont know how to achieve the remaining part of the drill down from project as
1. order and tickets grow in size on a daily basis.and
2. I considered them as degenerate dimesions.
Can some one suggest me how to approach this requirement?
Thanks in Advance,
Rama
I got an issue with rapidly changing dimension.
I am explaining a scenario.
In a company XX, Customer creates Projects(A project contains products) when he buys some thing from XX. The system internally creates orders for each project and the tickets are generated for each order. Tickets contain all the sale information, quantity, whose delivering the product.
Our client is requesting the drill down from Customer->Project->Order->Ticket.
I considered Order and ticket as degenerate dimensions as they grow in size along with fact table, but I thought this wont satisfy the above requirement because for drill across we need to have order and tickets as stand alone dimensions.
I snowflaked customer and project to achieve drill down from Customer->Project. I was struck here and from here I dont know how to achieve the remaining part of the drill down from project as
1. order and tickets grow in size on a daily basis.and
2. I considered them as degenerate dimesions.
Can some one suggest me how to approach this requirement?
Thanks in Advance,
Rama
praneeth61- Posts: 2
Join date: 2009-03-20
Similar topics» Rapidly Changing Dimensions
» Rapidly changing Monster dimension...
» Rapidly Changing Dimension
» Rapidly Changing Dimension for Manufacturing DWH
» Slowly Changing Dimensions - Design Review (Need More Clarification)
» Rapidly changing Monster dimension...
» Rapidly Changing Dimension
» Rapidly Changing Dimension for Manufacturing DWH
» Slowly Changing Dimensions - Design Review (Need More Clarification)
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum