I am working on ER diagram for a tabular model(SSAS), so converted my model to XMLA file, but my ER diagram tool is accepting only xml format files. So, I need info how to convert my xmla file to xml.
Asked
Active
Viewed 476 times
1 Answers
0
XMLA files will be of the format JSON. You can easily convert XMLA files into XML files using python.
import json
from json2xml import json2xml
with open('XMLA.xmla') as xmlafile:
data = json.load(xmlafile)
print(json2xml.Json2xml(data).to_xml())
Vishnu Mohan
- 31
- 6
-
Hi @Vishnu, I am a beginner in Python, so I tried the above commands and it didn't work, are you sure it is working and this conversion works for xmla? – user3132623 Sep 15 '19 at 20:25
-
Hey, are you able to load .xmla file to Python using json.load() function? – Vishnu Mohan Oct 16 '19 at 04:48