Semantic Model SMML export as documentation
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
Best Answers
-
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.
2 -
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.2
Answers
-
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.
2 -
Yes, its not included in the Semantic Modeler , you need to follow the standard process using Admin tool only.
Regards,
Arjun
1 -
@Pravin Janardanam-Oracle - can comment on any public roadmap plans for metadata dictionary.
0 -
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.
0 -
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.
0 -
@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.
3
