EDW Design Decision

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
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
See also
more_less
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"