[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

BI Query saved in Excel workbook

Posted on 2007-03-21
3
Medium Priority
?
835 Views
Last Modified: 2013-12-08
Can someone please clarify these 2 BI Query questions (version 7):
 1. If I open a query workbook that is stored on the BI server and refresh it and then save it to a  drive on a server other than the BI server as an .XLS file, can that XLS workbook still refresh the query and retrieve data into the XLS workbook on the non-BI server, as if it were on the BI server,  or only if it has certain connectivity, or not at all?  In other words, do I lose all BI functionality when saving it off of the BI server or can I save it as an XLS file on the BI server and still maintain the ability to refresh the query.
and 2. as above, at what point do I lose the capability to drill back into my transaction data in ECC.
Thanks!
0
Comment
Question by:daveo21
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 10

Expert Comment

by:jonvaughan
ID: 18781043
The excel BI reports use extensive VBA programming to work, but to refresh data you will still need to be able to connect to the BI server. At what point you can't do that im not sure, you can save the Reports onto your workstation and still connect back in later .... tho im not sure that is what you are asking ...
0
 
LVL 3

Author Comment

by:daveo21
ID: 18783613
Can you elaborate a little on what you mean by extensive VBA programming to work.  I am very good in VBA and regular Excel, but would be interested in the knids of things that need to be done in VBA for the BI to work in, not looking for code just examples.
Many Thanks
0
 
LVL 10

Accepted Solution

by:
jonvaughan earned 1500 total points
ID: 18792628
The plug BI excel plug in has all the excel side code - it is generated as the report is generated.
0

Featured Post

What’s Wrong with Your Cloud Strategy ?

Even as many CIOs are embracing a cloud-first strategy, the reality is that moving to the cloud is a lengthy process and the end-state is likely to be a blend of multiple clouds—public and private. Learn why multicloud solutions matter in this webinar by Nimble Storage.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Messaging apps are amazing tools with the power to do a lot of good, but the truth is the process of collaborating with coworkers requires relationships established through meaningful communication - the kind of communication that only happens face-…
These days socially coordinated efforts have turned into a critical requirement for enterprises.
Video by: ITPro.TV
In this episode Don builds upon the troubleshooting techniques by demonstrating how to properly monitor a vSphere deployment to detect problems before they occur. He begins the show using tools found within the vSphere suite as ends the show demonst…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

649 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question