Home » Fusion Middleware & Colab Suite » Business Intelligence » degenerated dimensions (OBIEE, 10.1.3.3, XP)
degenerated dimensions [message #298307] Tue, 05 February 2008 11:30 Go to next message
rew65
Messages: 4
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 Go to previous messageGo to next message
skooman
Messages: 913
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 Go to previous messageGo to next message
rew65
Messages: 4
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 Go to previous messageGo to next message
skooman
Messages: 913
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 Go to previous message
rew65
Messages: 4
Registered: February 2008
Junior Member
That is what I was feeling about but was not sure.
Appreciate it so much...
Previous Topic: Prompts On One Page
Next Topic: Is there any software?
Goto Forum:
  


Current Time: Thu Mar 28 11:34:21 CDT 2024