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!

Multi key (or composite key) dimension for operational reporting

Flamingo-OracleJan 21 2013 — edited Jan 21 2013

Hi, I am creating operational reports in OBIEE 11g with PeopleSoft FSCM as source. As they are straight forward reports, I am planning to use OLTP tables directly for my OBIEE reporting.

Here is the simplified scenario - ACCOUNT_TBL_VW is dimension table which has BUSINESS_UNIT & ACCOUNT_ID as keys.
I have LEDGER Fact that has BUSINESS_UNIT, ACCOUNT_ID & other dimension keys with amount measures.

How do I link my LEDGER Fact with ACCOUNT Dimension?

Can I join multiple keys of Dimension with multiple keys of Fact? like this

ACCDIM.BUSINESS_UNIT ---> LEDGFACT.BUSINESS_UNIT
ACCDIM.ACCOUNT_ID ---> LEDGFACT.ACCOUNT_ID

As it is operational reporting, I don't have any ETL type process to prepare single column primary key(surrogate key) in Dimension Table & modifying Fact Table with dimension surrogate key value.

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 18 2013

Added on Jan 21 2013

#11g, #business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee, #obiee, #reporting

1 comment

465 views