2 Replies Latest reply on Oct 10, 2018 8:16 AM by Joel Acha

    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

        • 1. Re: OBIEE 12c RPD database features export
          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/

          1 person found this helpful
          • 2. Re: OBIEE 12c RPD database features export
            Joel Acha

            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 Oracle11g
            FEATURES (
            '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',