Solved

BI Query saved in Excel workbook

Posted on 2007-03-21
3
828 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
  • 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 500 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

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

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

Note: You must have administrative privileges in order to configure lead or case queues. Salesforce.com (http://www.Salesforce.com) is a cloud-based customer relationship management (CRM) system. It is widely used around the world by sales and ma…
Note: You must have administrative privileges in order to create/edit Sharing Rules. Salesforce.com (http://www.salesforce.com) (SFDC) is a cloud-based customer relationship management (CRM) system. It is a database most commonly used by sales an…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …

777 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