Need steps to extract Universe into Excel format in BI42

[former_member589655]

Need steps to extract Universe into Excel format in BI42?

Could someone please provide me the steps to achieve the same ?

[denis_konovalov]

I have fixed your tag, please select more careful next time.

[mhmohammed]

Hi,

With the new BO 4.2 SP7 version, you can save a Universe from IDT to PDF or HTML or TXT format. You can try to download the Universe to TXT, and then import it in Excel (you'll have to be careful with the delimiters when doing that though)!

Thanks,
Mahboob Mohammed

[amitrathi239]

check attached links.

http://biclever.com/blog/unx-universe-documentation/

https://blogs.sap.com/2016/07/20/how-to-export-universe-objects-into-an-excel/

[former_member185603]

there is no out of box solution to extract the universe to Excel. Either you need to use SDK or use some 3rd party tools like 360.