| degenerated dimensions [message #298307] |
Tue, 05 February 2008 11:30  |
rew65
Messages: 3
Registered: February 2008 |
Junior Member |
|
|
Hi,
My fact table has two columns that are degenerated dimensions. What is the modeling approach in this case? Should I create two views as dimensions to build business model like "create views <dimension_name> as select distinct <column_name> from <fact_table>"?
Appreciate your help....
|
|
|
| Re: degenerated dimensions [message #300170 is a reply to message #298307 ] |
Thu, 14 February 2008 08:41  |
skooman
Messages: 794
Registered: March 2005
Location: Netherlands |
Senior Member |
|
|
|
Why should you want to do that? Only reason I see is that it looks nice and clean if users want to create requests and the presentation tables are organized into dimensions and facts. But purely from a modelling standpoint I see no reason to create dimension tables if all data is in the fact tables already.
|
|
|
| Re: degenerated dimensions [message #300270 is a reply to message #300170 ] |
Thu, 14 February 2008 17:48 |
rew65
Messages: 3
Registered: February 2008 |
Junior Member |
|
|
Well, but BM force me to join fact table to at least one dimension and my fact table has that degenerated dimension only.
|
|
|
| Re: degenerated dimensions [message #300343 is a reply to message #300270 ] |
Fri, 15 February 2008 02:16 |
skooman
Messages: 794
Registered: March 2005
Location: Netherlands |
Senior Member |
|
|
|
Ok, so you do not have any dimension at all. Indeed, just for the sake of the Business Model to be consistent, you have to create one fake dimension, true (you don't even have to include that in the presentation model).
|
|
|
| Re: degenerated dimensions [message #300474 is a reply to message #300343 ] |
Fri, 15 February 2008 09:49 |
rew65
Messages: 3
Registered: February 2008 |
Junior Member |
|
|
That is what I was feeling about but was not sure.
Appreciate it so much...
|
|
|
]
Members
Search
Help
Register
Login
Home
