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!

How can we let OBI EE ignore an Implicit Fact Table Column when creating a column based prompt limit

Manoj DixitAug 17 2016 — edited Aug 30 2016

Hi,

I have a subject area containing several fact tables. An implicit fact table column has already been specified. This column is based on 'select 1 Dummy from dual' select table type in physical layer.

I want to add a new prompt to an existing Dashboard Prompt. This prompt should be limited to All Prompts. The issue is since there is already an implicit fact table the LOVs are nothing but a Cartesian product (all rows from all dimensions available on the Dashboard prompt).

Is there any way to specify to ignore the implicit fact table and actually use the correct fact table to display the LOVs for the new prompt? Or how could the new prompt be designed?

If the suggestion is to remove the Implicit Fact table from the Subject Area, how to do an impact analysis of this change?

OBI EE version is 11.1.1.7.0.

Any questions, please let me know.

Thank you.

Regards,

Manoj.

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 27 2016

Added on Aug 17 2016

#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee

7 comments

1,188 views