cia0417 at 22h45
13
Jul
2009
EDW Design Decision
There is currently a difference of opinion on how the EDW should be structured for ad-hoc reporting. One camp suggests that the dimensional design can easily support both ad-hoc and analytical reporting. While the other suggests that the dimensional model should not be used for ad-hoc purposes since it is not easily understood by end-users. This other camp wants to create a flat structure for ad-hoc reporting. Any opinions on what should be done? Thanks in a
There is currently a difference of opinion on how the EDW should be structured for ad-hoc reporting. One camp suggests that the dimensional design can easily support both ad-hoc and analytical reporting. While the other suggests that the dimensional model should not be used for ad-hoc purposes since it is not easily understood by end-users. This other camp wants to create a flat structure for ad-hoc reporting. Any opinions on what should be done? Thanks in a
About
This topic belongs to the forum
Data Warehousing and Business Intelligence based on dimensional modeling and the Kimball Lifecycle.
- Numbers of topics : 1858
- Numbers of messages : 8714
- Numbers of users : 3801
- Numbers of points : 1672
Similar topics
Hi,
I am fairly new to dimensional modelling and have been struggling with a problem for a couple of days now. I currently have a fact table which stores incidents/problems with orders that are sent to customers. The system from which this incident dat
Hi,
Do you have a PCB Layout Design Guide for S5PC110?
Regards,
Howie
Hi,
I am designing a Sales DW where we can have multiple discounts on a given transaction line.
I created a SalesTransaction (ST) fact table and a SalesDiscount (SD) fact table.
In the current design the ST table has its own key that is a bigint
hi I am faced with a problem designing a transaction fact in an investment firm. each transaction represents a trade the traders put in (buy,sale etc).
The problem I am facing is: the metrics of a transaction change from one day to another day so a
Forum Design - The Community of Web Designers
Choice of the category: Computers and Internet
Choice of a title: The Design Forums - The Community of Web Designers
Forum address: http://www.thedesignforums.net/forum
Main language: English
Forum
Forums from same category
Free forum : hi. Free forum : 2709rsgamboa6219. Free forum,
Free forum : Forum IT Teknik Komputer dan Jaringan SMKN 1 SLAWI
HmongThoobNtiajTeb. com/
LEGO Island Discussion, modding, news and more!
Techy Boards, a growing technology discussion forum! For fans of nintendo, xbox, playstation or anything else!
Search
Informations
4 Replies For the topic :
"EDW Design Decision"
This topic has been viewed 1727 times.
Last message :
13/07/2009 at 22h45 by "cia0417"






