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
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/
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',
Prepare-se para sua certificação em OCI AI Foundations Inteligência Artificial está transformando a forma como empresas desenvolvem aplicações, automatizam processos e utilizam seus dados. Para aproveitar esse potencial, é essencial compreender os principais conceitos de IA e como essas tecnologias se conectam aos serviços…
it is observed that in OAC while using case statements the output is not expected.For example if we have a case statment like case when table1.column1=table2.column1 then 'yes' else 'No' end as Attribute1 Now if i use this attribute with a fact-amount column attribute 1|| Amount on a report then we dont get the aggregation…
Once I select that value from the list box Region I created, I want to filter the table by my selection. See the images
Hi, While using OAS or OAC latest version can we generate a report to view complete defition of semantic model/subject area. It helps to document and troubleshoot. thanks
I want to export all OAC RPD joins and conditions, is there a way to export or extract joins information. please suggest. Repository documentation doesn't gives joins, if any other way pls suggest.
