Import Column and Table name descriptions to OBIEE RPD

KashSidd

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:

    

OBIEE Version: 12.1.3.0

[Deleted User]

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

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

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

Gianni Ceresa

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

"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

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

Gianni Ceresa

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

"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