Oracle Business Intelligence Applications

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Business Intelligence Applications

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Obiee RPD how enable hint field

Received Response
135
Views
4
Comments
1037520
1037520 Rank 4 - Community Specialist
in Oracle Business Intelligence Applications

Hello,

I need adding a hint physical table from OBIEE, but my RPD does not show the hint field.

I'm working obiee 12c.

Does someone know how enable it??

I attach an image.physical table rpd properties.png

Thanks a lot.

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Which "12c"?

    Is this a custom RPD or something you started on top of OBIA?

    What type of database is the parent object?

  • 1037520
    1037520 Rank 4 - Community Specialist

    Obiee 12c version 12.2.1.2.0 , sqlserver database is the datawarehouse.

    A custom RPD.

    Tnks for your help!!!

  • Gianni Ceresa
    Gianni Ceresa Mod

    If you want to set a hint on the physical table ... move your datawarehouse to an Oracle database.

    As you can see in the following picture it's still there (this is from 12.2.1.2.0). But the field is there only when the database type is set to on Oracle DB. If the database type is set to SQL Server or DB2 or something else the field goes away.

    Capture.PNG

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Gianni beat me to it but that just means you have a non-Oracle DB as a source. No other database has the hint.