I can see list of reports pointing to specific universe in CMC.
CMC–Universes–>Right click on Universe–>Tools–Check Relationships–Query Results window open and can see list of reports pointing to the universe along with additional infomraiton such as Folder, Data level security, connection, access level of the universe.
Trying to export universe details from Query results into CSV but not able to. I login as an Administrator.
How to make ‘Export to CSV’ option enable in Query Results application in CMC?
Never worked (for me) in CMC.
Yes, the new BI 4.2 should have a “BI on BI universe”, so that may help.
There’s something else : search for “BIclever” ( I think it’s a dot-com site) and test their “freeware tools” : windows programs who can either “analyse” your universes (unv or unx) OR the CMC through … making the QueryBuilder results exportable.
Yoy need the BI libraries on your machin, but as an admin or developer you probably have them.
It worked really well, though SOME options can have your desktop and/or your server “choke” on the mere load of analysis.
IIRC, the tool you are looki,g for is named “CMS query builder”
The web-version included in CMS is “query builder” or “BI query Builder”, but has lousy export facilities.
( though in some browsers “copy all page” and then “paste into wordprocessor” may work. And could be then scripted (vim, emacs, some wordpad extensions … ) to “clean it up”.
With the ‘button’ export to CSV unavailable it seems useless that it cannot be switched on otherwise it might as well be a banner that says ‘SAP DUMMY Button’
(BOB member since 2002-08-29)
(BOB member since 2007-06-18)
(BOB member since 2006-09-06)