Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Obiee Multiple Fact Report Question

dilekJul 21 2017 — edited Jul 25 2017

Hello obiee gurus,

I am an obiee expert, and I always question points that I do not understand clearly. So here is one of my ambiguity :S

It's about multiple fact reports. I know obiee content logic, it is important for multiple fact reports, so I set content level for all defined dimensions then I can create the report as I want. However, this case requires a strict fact table design. It must include only measure columns and dimensional columns (which joins a physical dimension table). What is the core reason under this obiee content logic? Is this same for different reporting tools such as cognos, ms strategy etc. (I've never used them)? Is this a powerful side of obiee, or not? I realy want to be clear :S

Thank you four your attention.

Regards,

Dilek

Comments

John_K

Well, if you have two facts and you want to combine them, then they need to contain the same set of dimensions. Imagine you have two facts - cars and people. Cars have a num_wheels dimension and people have a hair_colour dimension. It makes no sense to report how many people have four wheels!!

You can actually combine facts at different dimensionality though using the FILTER clause. See here: Combining Facts/Subject Areas in Oracle OBIEE - Part 2 - Beyond Blog

Christian Berg-0racle

OBI at ist core is a source agnostic query Generator for any source there is.

Logical dimensions and Logical Facts are - as their "Logical" bit of the Name implies - actually completely artificial concepts and have Zero to do with the physical model in the strictest sense of the word. I can happily and easily create a 10 fact, 30 Dimension model where only 4 dims will ever be conformed on one single flat file.

You must comprehend this to comprehend why OBI does things the way it does them.

a) all business model concepts are virtual

b) don't even think "this Logical Dimension just means a dimension table" - through multiple LTSs and multiple tables nested inside each LTS I can create you a "Dimension" which - while a logical entity - is sourced from 20 physical sources, 2 being tables, 4 being cubes, 11 being XML and 3 coming from Hadoop

Yes this is the strongest feature of the NQuire Server which people still don't get comprehend 20 years after its inception.

1 person found this helpful
Thomas Dodds

Every fact has a dimensional context

Every dimensional attribute is related through a fact (conformed dimensions & implicit facts)

Use of information drives fact star design (typically a related set of business questions are answered by a single fact star)

+ to @"Christian Berg"

^ the basic rules

1 person found this helpful
Christian Berg-0racle

True, but contrary to breathing and heartbeat they don't happen automagically

1 person found this helpful
1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 22 2017
Added on Jul 21 2017
#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee
4 comments
300 views