Need for a dimensional modeling tool?

Andrea Vincenzi at 19h59
02
Feb
2011
Need for a dimensional modeling tool?

I'd like to hear opinions from members of this group about the need for a modeling tool that's more oriented towards dimensional models.
Most of us use Erwin or a similar modeling tool, which is designed for general E/R modeling (to be honest, Erwin also has a few features for dimensional models, but they are quite limited).
A modeling tool oriented toward dimensional models should be able to understand concepts like facts (with meas

Read more
Reply
About
This topic belongs to the forum

  • Data Warehousing and Business Intelligence based on dimensional modeling and the Kimball Lifecycle.

  • Numbers of topics : 1842
  • Numbers of messages : 8656
  • Numbers of users : 3787
  • Numbers of points : 1497
Similar topics
Migration to Dimensional Modeling - Testing
Hello, I migrated a relational database to dimensional modeling database. I need to test that all the information in the source system is there in the target system. One technique which can be used is... - to calculate the number of records in the
Modeling help on dimension with many boolean value
Hi I'm really stuck on how to model a user need/business need Basically, we are in the healthcare and we have a software that manage the work of the paramedics in ambulances. There is a table that store all standard informations about the work of
Advantages of Dimensional Modeling
Hi I have few questions on advantages of dimensional modeling as provided in the book DWH Lifecycle Toolkit by Ralph. (1) In the book , on Page 150, it is mentioned that "Aggregation software packages and utilities depend on a very specific single
Schemas ... in the final dimensional models (BI database)
Hi quick question ... We are planning to have 2 or three staging databases. 1) Staging 2) Conforming and then finally the actuall BI database 3) DataWarehouse My question, in this final final database (3) should we use schemas to 'group
Adherence to dimensional modeling in practice
I prefer following dimensional modeling principles especially those proposed by Kimball and most of the techniques discussed in this forum, I hear a lot of comments from colleagues and friends that dimensional principles are more bookish and no one follow
Forums from same category
See also
more_less
Informations

2 Replies For the topic :
"Need for a dimensional modeling tool?"

This topic has been viewed 2220 times.

Last message :
02/02/2011 at 19h59 by "Andrea Vincenzi"