OBIEE 12c RPD database features export

Antonija Mandić

Hi,

Is there a way to export database features found in RPD?

Or perhaps is there a file where I can find this info?

Kind regards,

Antonija

Robert Angel

Convert a copy of your rpd to XML and just search through that, or use a piece of middleware to do the same; -

https://www.datavail.com/blog/art-of-bi-converting-the-obiee-repository-file-rpd-into-a-xml-xml-file/

Joel

Right Click on the Database icon and click on copy then paste in your text editor of choice and you should get output (just an excerpt) similar to this:

DECLARE DATABASE "DBName" AS "DBName" TYPE Oracle11gFEATURES ('LEFT_OUTER_JOIN_SUPPORTED' = 'Yes','RIGHT_OUTER_JOIN_SUPPORTED' = 'Yes','FULL_OUTER_JOIN_SUPPORTED' = 'Yes','NESTED_OUTER_JOIN_SUPPORTED' = 'Yes','UNION_SUPPORTED' = 'Yes','UNION_ALL_SUPPORTED' = 'Yes','COUNT_SUPPORTED' = 'Yes','COUNT_DISTINCT_SUPPORTED' = 'Yes','COUNT_STAR_SUPPORTED' = 'Yes','SUM_SUPPORTED' = 'Yes','AVG_SUPPORTED' = 'Yes','MIN_SUPPORTED' = 'Yes','MAX_SUPPORTED' = 'Yes','FIRST_SUPPORTED' = 'Yes','LAST_SUPPORTED' = 'Yes','RANK_SUPPORTED' = 'Yes','PERCENTILE_SUPPORTED' = 'No','MOVING_AVG_SUPPORTED' = 'No','TOPN_SUPPORTED' = 'Yes','BOTTOMN_SUPPORTED' = 'Yes','GROUP_BY_SUPPORTED' = 'Yes','GROUP_BY_EXPR_SUPPORTED' = 'Yes','HAVING_SUPPORTED' = 'Yes','PARAMETERS_IN_HAVING_CLAUSE_SUPPORTED' = 'No','ORDERBY_SUPPORTED' = 'Yes','EXPRESSIONS_IN_ORDERBY_SUPPORTED' = 'No','ORDER_BY_COLUMNS_IN_SELECT_SUPPORTED' = 'No','NULL_VALUES_SORT_FIRST' = 'No','DISTINCT_SUPPORTED' = 'Yes','CASE_LOOK_UP_SUPPORTED' = 'Yes','CASE_IF_SUPPORTED' = 'Yes','DATE_LITERAL_SUPPORTED' = 'Yes','TIME_LITERAL_SUPPORTED' = 'Yes','DATE_TIME_LITERAL_SUPPORTED' = 'Yes','INTERVAL_LITERAL_SUPPORTED' = 'No','CURDATE_SUPPORTED' = 'No','CURTIME_SUPPORTED' = 'No','NOW_SUPPORTED' = 'No','CALENDAR_EXTRACT_DAY_SUPPORTED' = 'Yes','CALENDAR_EXTRACT_DAY_OF_QUARTER_SUPPORTED' = 'No','CALENDAR_EXTRACT_DAY_OF_YEAR_SUPPORTED' = 'Yes','CALENDAR_EXTRACT_HOUR_SUPPORTED' = 'Yes','CALENDAR_EXTRACT_MINUTE_SUPPORTED' = 'Yes','CALENDAR_EXTRACT_MONTH_SUPPORTED' = 'Yes','CALENDAR_EXTRACT_MONTH_OF_QUARTER_SUPPORTED' = 'Yes','CALENDAR_EXTRACT_QUARTER_OF_YEAR_SUPPORTED' = 'Yes','CALENDAR_EXTRACT_SECOND_SUPPORTED' = 'Yes','CALENDAR_EXTRACT_WEEK_OF_QUARTER_SUPPORTED' = 'No','CALENDAR_EXTRACT_WEEK_OF_YEAR_SUPPORTED' = 'Yes','CALENDAR_EXTRACT_YEAR_SUPPORTED' = 'Yes','CALENDAR_EXTRACT_WEEK_OF_MONTH_SUPPORTED' = 'Yes','CALENDAR_EXTRACT_SHORT_NAME_OF_MONTH_SUPPORTED' = 'Yes','CALENDAR_EXTRACT_DAY_OF_WEEK_SUPPORTED' = 'Yes',