BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Sunset Ride 
Sunset Ride 

General Notice: BOB is going to retire...please see details here. All BOB forums have been converted to "read only" as of September 1st.
General Notice: No events within the next 45 days.

Query Results in CMC --Export to CSV- 4.2 SP6


 
Search this topic... | Search CMC... | Search Box
Register or Login to Post    Forum Index -> Security and User Administration -> CMC  Previous TopicPrint TopicNext Topic
Author Message
MIUSA
Principal Member
Principal Member



Joined: 30 Apr 2011

Posts: 295



PostPosted: Fri Nov 09, 2018 12:28 pm 
Post subject: Query Results in CMC --Export to CSV- 4.2 SP6

Hi, All

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?

We are in 4.2 SP6.

Thank you for the help!
Back to top
joepeters
Forum Fanatic
Forum Fanatic



Joined: 29 Aug 2002

Posts: 6705
Location: Connecticut, USA


flag
PostPosted: Mon Nov 12, 2018 10:18 am 
Post subject: Re: Query Results in CMC --Export to CSV- 4.2 SP6

Can't do it in CMC, but you might be able to create a WebI report using the "BI on BI" universe, then export the results of the report.
Back to top
RensH
Principal Member
Principal Member



Joined: 18 Jun 2007
ASUG Icon
Posts: 146


flag
PostPosted: Wed Feb 06, 2019 11:29 am 
Post subject: Re: Query Results in CMC --Export to CSV- 4.2 SP6

MIUSA wrote:
Hi, All

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?

We are in 4.2 SP6.

Thank you for the help!


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".

_________________
Transitioning to : XI 4.2 (SP3)
(Mostly WebI docs using universes, no voyager etc -yet- but (very few) dashboards )
LDAP eDirectory , repository on oracle.


Phasing out : BI 4.1 SP5 . Mostly Webi.
Phased out : BO-XI 3.1 SP6 . Mostly Webi.
Phased out : BO651, full clients. No Webi.
Back to top
BarkyBaloo
Principal Member
Principal Member



Joined: 04 Jul 2007

Posts: 171



PostPosted: Thu Feb 28, 2019 4:24 am 
Post subject: Re: Query Results in CMC --Export to CSV- 4.2 SP6

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'
Back to top
Sree Konduri
Principal Member
Principal Member



Joined: 14 Jul 2005

Posts: 266



PostPosted: Fri Mar 01, 2019 3:04 pm 
Post subject: Re: Query Results in CMC --Export to CSV- 4.2 SP6

Export to CSV only for security queries (not for raltionship queries) in 4.2 SP4

Thanks
Back to top
Seagrass
Senior Member
Senior Member



Joined: 18 Nov 2014

Posts: 32



PostPosted: Tue Aug 27, 2019 3:40 pm 
Post subject: Re: Query Results in CMC --Export to CSV- 4.2 SP6

I just submitted this as an improvement request in Customer Influence.

Just need some votes.... hint hint hint. thumbsup.gif
Back to top
TurningPointHolland
Principal Member
Principal Member



Joined: 06 Sep 2006

Posts: 362
Location: Gorinchem, Holland


flag
PostPosted: Fri Jul 03, 2020 6:19 am 
Post subject: Re: Query Results in CMC --Export to CSV- 4.2 SP6

Same problem here.

If you can not export the result why is the button over there? icon_rolleyes.gif

_________________
Ton Vermeij
Senior SAP BI, Lumira, PowerBI, Tableau and Alteryx Consultant
Gorinchem, Holland, Europe
Owner of www.theturningpoint.nl and co-founder of
www.bi-united.nl (dutch BI-freelancers network)
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Security and User Administration -> CMC  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0292 seconds using 18 queries. (SQL 0.0025 Parse 0.0009 Other 0.0258)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo