Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

Import Column and Table name descriptions to OBIEE RPD

Received Response
41
Views
8
Comments
KashSidd
KashSidd Rank 5 - Community Champion
edited Aug 13, 2024 5:26PM in Oracle Analytics Cloud and Server

Is there a way to import your Column and Table name descriptions to the RPD Presentation Layer instead of having to to defining one by one? Here is the screenshot:

     pastedImage_0.png

OBIEE Version: 12.1.3.0

Answers

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

    A "Presentation Table" is a completely artificial concept and does not represent a table in your database 1 : 1.

    Hardly any one database table will equal one physical table in the RPD which will equal one logical table which will equal one presentation table.

  • Gianni Ceresa
    Gianni Ceresa Mod

    Hi,

    The thing going in that direction could be the "Externalize Strings" utility. You find it in Tools > Utilities.

    Read the doc of that utility to find out if it's useful for your need (and if it doesn't cause more issues than what it solves).

  • KashSidd
    KashSidd Rank 5 - Community Champion

    Thanks Gianni for your reply and I had already tried that one but I guess thats not really what its used for

  • Gianni Ceresa
    Gianni Ceresa Mod

    Well ... by using it I can get a CSV file with the place to put my own description and populate them all at once. This CSV could easily be generated by any kind of tool or language.

    If that's not what you look for, you maybe want to express a proper use case with all the details.

  • KashSidd
    KashSidd Rank 5 - Community Champion

    "Well ... by using it I can get a CSV file with the place to put my own description and populate them all at once."

    I was following Doc ID 1289344.1 and it seems that its for languages but let me try and see if it also works for descriptions to the Presentation Tables and Columns

  • KashSidd
    KashSidd Rank 5 - Community Champion

    To save time, please let me know if you or anyone have tried this to populate Physical Table and Column descriptions?

  • Gianni Ceresa
    Gianni Ceresa Mod 
    KashSidd wrote:To save time...

    Hire a consultant.

    And reading a document related to 11.1.1.3 without reading about the functionality itself, understanding what it does, and be able to think a bit outside of the box to turn it into what you need, will not save you any time.

    Good luck !

    PS: a screenshot of a Presentation table and you now talk about Physical table? Different way of doing things as it's 2 very different things.

  • KashSidd
    KashSidd Rank 5 - Community Champion

    "a screenshot of a Presentation table and you now talk about Physical table? Different way of doing things as it's 2 very different things."

    My bad, its Presentation table and was a typo

    And reading a document related to 11.1.1.3 without reading about the functionality itself, understanding what it does, and be able to think a bit outside of the box to turn it into what you need, will not save you any time.

    Hey Einstein! It was a simple question, have you done it yes or no