Solved

BI Query saved in Excel workbook

Posted on 2007-03-21
3
826 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

If you have problems displaying reports in CRM after a new installation, review the following steps: Check that SQL Server Reporting Services is working On the server that has SQL Server Reporting Services (SQL SRS) installed, check that the S…
I showed you how to use console view (HERE (http://www.experts-exchange.com/articles/18379/Getting-Started-and-Using-the-Salesforce-com-Console.html)) -– but how do you set it up on the admin side of Salesforce? Note that you have to have Admin leve…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…

911 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now