Implicit Fact Column in OBIEE - OBIEE GURU

govtjobonline-Latest Government Jobs 2023 Recruitment Notifications

Latest Govt Jobs Whatsapp Group Links-Telegram

For Latest Govt Jobs 2023 or for Freejobalerts or Join

Latest Government Jobs 2023

Friday 27 January 2012

Implicit Fact Column in OBIEE


    What is Implicit Fact Column and how it is defined?

    In case we have multiple Fact tables, then it is a best practice to set an implicit fact column. Setting an implicit fact has two benefits.
    1.     An implicit fact column help BI Server choose the join path when multiple join paths are available between facts and dimensions.
    2.     When a report is generated only from dimension tables, it will result in an error as an Analyses should always consist of at least one fact or measure. To overcome this error we define an implicit fact column. This ensures that a fact is always included in the SQL generated by BI Server.

    To set an implicit fact column:
    Ø  In presentation layer, double click the presentation catalog/ go to properties of presentation catalog.
    Ø  In the general tab, find the Implicit Fact Column section.
    Ø  Click on Set… button, this will open the browse window to select a fact column from the fact tables available in the presentation catalog.
    Ø  Select the column.
    Ø  Click OK.
    Ø  Ensure that the selected Implicit Fact Column is displayed in the Implicit Fact Column section in the general properties of Presentation Catalog.
    Ø  Click OK.
    Ø  Save your changes in the repository.

    Whatsapp group

    Govt Jobs Whatsapp Group Links 2023

    Telegram group

    Govt Jobs Telegram Group

    Facebook group

    Govt Job Online Facebook Group

    Follow on Facebook group

    Govt Jobs Online Facebook Page

    Subscribe to Youtube Channel

    Govtjobsonline Youtube

    Join Latest Govt Jobs Telegram Group here

    Join Government Jobs Whatsapp Group here (State Wise)

    Join State Wise Sarkari Results Telegram here

    1. ITI Jobs Notifications
    2. ITI Apprenticeship Program
    3. Diploma Jobs Notifications
    4. Engineering Jobs Notifications
    5. UPSC Jobs Notifications
    6. Court Jobs Notifications
    7. Staff Nurse Jobs Notifications
    8. NHM Jobs Notifications
    9. Exam Syllabus and Pattern
    10. SSC Recruitment

    No comments:

    Post a Comment

    Latest Govt Jobs Vacancy 2023