Hello So we have a huge instance of OBIEE. With many tables in view of AdminTool. I want get SQL text from 'table type -select' of AdminTool automaticaly. I try Catalog Manager for this ..but useless. How i can do this? Can you help me
Quick way would be in the Admin Tool and in the Physical Layer, to right click on the physical schema for example and click on copy. Paste the content into your editor of choice and then search for the "TABLE TYPE SELECT DATABASE MAP" string. The SELECT statement should follow after this string.
Or a variant of @Joel_Acha suggestion is save your rpd as XML and then you can use your tool of choice to search / parse its content.
Wow great! Thanks! Your way is perfect for me! because we have a very huge instance
No problem!
Thanks are appreciated here!
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.
