Hello,
We would like to produce an XML or XLS file with the documentation present in our presentation layer of our semantic model.
How can we achieve this please ?
Regards.
Jean-Pierre
Hi Jean-Pierre,
One solution could be exporting and downloading the semantic model to RPD file following these steps:
Export a Semantic Model:
Download an Exported .rpd File:
Then you can open the RPD file on offline mode using the Admin Tool.
Go to Tools -> Utilities... -> Generate Metadata Dictionary. It will generate the metadata in XML format.
Also, you could also export to zip file, which will generate files in JSON format inside. Then you could use Python to handle the JSON fiels.
Regards,
Ezequiel.
Hi @Cindy Owings-Hutchison It sounds like you are proposing an Idea Lab request (enhancement). Please check this one.
If it is what you are seeking, please up-vote and comment the Idea. If not, please file a new one. Since this is a discussion, and not an Idea, your request may be overlooked here.
Hi @Jean-Pierre Hoedenaeken ,
It's not possible to produce the Repository Documentation directly from the Semantic Modeler. You have to export it as RPD file and use the Admin tool.
Yes, its not included in the Semantic Modeler , you need to follow the standard process using Admin tool only.
Arjun
@Pravin Janardanam-Oracle - can comment on any public roadmap plans for metadata dictionary.
Access to the semantic model presentation layer metadata should be on the roadmap for this product. Users sharing data that is extracted from these tools often want to include the dictionary of descriptions and having it available would ease their burden.
Yes! This would be so helpful to those of us who support large organizations and have a lot of models to support. It would also help us keep our data dictionaries up to date or at least related to the data in analytics.
@Cindy Owings-Hutchison , while probably not what you look for as you expect (rightfully) the tool to cover the need, the json format of the semantic model is simple enough to easily generate any kind of documentation you need with a simple script. The older MDS XML format had tons of IDs and UIDs and also some FQDN defining relationships between objects, and had a number of extra layers in the code, the new json is a lot more straightforward.
Where AI meets business outcomes Oracle AI World brings the Oracle community together to explore how AI and other technology innovations are driving real business outcomes across industries. Discover what’s new through: Mainstage keynotes to hear the latest directly from Oracle leadership Product demonstrations Customer…
I tried the following expression and it blows up when I select more that one value in the list see image
We are using Oracle Analytics Server 2026 with WebLogic Server 14.1.2. Our Account Statement report is accessed through '/xmlpserver'. We need to capture the following details in the OAS/Publisher log files whenever a user runs the report: Username Report name and path Report execution timestamp Account Number From Date To…
We need to download a report with the order number as the file name. In the main report, we have a data action (hyperlink) on each order number. When we click an order number, the linked report is downloaded with the corresponding order details. Currently, the file is downloaded using the report name. We need to download…
Hi all I work in UK healthcare across 30 hospitals nationwide, and we're currently reviewing our Oracle estate and roadmap. Part of that is deciding whether to make a case for investing further in Oracle Analytics Cloud for workforce reporting, or whether OTBI and our existing tools are enough for now. Our HR data sits in…
