I’ve missed something obvious I hope, but how do I enable users to save the result from a Webi document back to personal/public folders with a non-Webi format (pdf, xlsx, docx)?
They can export locally, but I want them to push back a pdf to be available in Launchpad instead of saving 25,000 versions of the same Webi document with some different Prompt values.
Under ‘Save As’ I have just Web Intelligence under “Save as Type”
Surely you don’t have to save it locally and then load it back up, so I must be missing something.
Hi Mark, you are probably understanding me correctly. In prior BO versions you could refresh/edit a Webi document and then save the results back to the CMC all from within Infoview because ‘Save As’ gave you the option to change the file type.
It doesn’t any more by the looks of it, as Save and Export have been split.
That seems a bit of a backward step for SAP. No way my business people will fart around scheduling a document just so they can adhere to my ideals around multiplying the no. of wid files.
That’s correct – a WebI report can only be scheduled to an instance or to an inbox. You can’t schedule it to another location in the CMS, and you can’t replace the original report.
Not really sure what you gain from saving back to the repository as an excel sheet but you could perhaps look at using LiveOffice. Still a bit convoluted I suppose but it’s a workaround nonetheless.
Thanks for the pointers. I’ll take a look at all the options.
Really I’m just thinking about when a user refreshes a report - even ad hoc - and they want a snapshot of that output, but retained within the BO environment so that others can also view it (in the context of the MI contained within InfoView).
Yes, they can output that to somewhere completely different in the shared file/print server environment, but not if I wanted to keep all that content within BO…
I guess instances are closest to this, but again that requires a scheduled approach, not an ad hoc approach. Not sure my lot really get instances in any case, though I could educate them.
Live Office kind of doesn’t achieve what I wanted I don’t think. I do use it but again not for ad hoc.
I’m also slightly unclear on the longevity of Live Office - can’t find anything concrete on that - I wonder where it sits on the long term SAP BI roadmap.
I’ve just committed to delivering a load of Live Office solutions for my company - in BI4.0 so that already stuffs any option to use IDT without a Universe maintenance headache - who want their Quarterly Board reporting & Financial MI driven from SAP BO, but with commentary in MS Word and some other data from MS Excel.
Did I miss some other magic SAP BO application/add-in that delivers this capability?
I agree it’s a bit of a dogs dinner, performs atrociously for anything remotely complex in Webi terms and is hardly a joy to use, but there’s nothing else (is there?) that I can use to plonk some Webi content in the middle of a Board Report, let people refresh (or schedule a refresh) from MS Word, and then snapshot as a de facto point in time record?
Must be a fairly common requirement… I’ve not had to do it before, but it seems quite reasonable for a business to expect such integration. Otherwise how do I move this 100 strong team of accountants away from Excel for everything involving numbers?
I’m always up for bashing BusObj…but not on this. LO works a charm for a lot of things and I’ve not had a problem with it. Volumes of data, yes but apparently that is addressed in 4.1
Well there’s LO so I guess there is no need for another tool
Enough said
Read that should be addressed, though to what degree I don’t know yet.
Not quite
–
It’s ludicrous that Excelsius and Explorer use only IDT and LO only works with unv formats.
Theres a lot there I don’t agree with. Finance users in particular want to get the data into Excel.
There might be mileage in combining it with “Analysis for Microsoft Office”. Doesn’t mean it won’t go away though, rather it will evolve. At least I do hope so.
Agreed :). They use Excel as it is their “tool of choice”, whether we like it or not.
Our “great” investment banking systems would die completely if Excel didn’t exist .
To be frank current Excel integration is poor, whether it is report outputs, or Live Office.
LO needs to handle volumes better, IMO, as well as unx, if it is going to become more popular.