Solved

BI Query saved in Excel workbook

Posted on 2007-03-21
3
824 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
Comment Utility
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
Comment Utility
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
Comment Utility
The plug BI excel plug in has all the excel side code - it is generated as the report is generated.
0

Featured Post

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Suggested Solutions

Oracle Apps Profiles option: A user profile is a set of shifting options that alter the way one runs an application. A value is set for each option under the user's profile when the Oracle application user logs on to any responsibility or changes…
Salesforce.com’s Console is a great tool to view activities, leads, contacts, accounts and opportunities all in one screen. It is particularly effective during call blocks and working numerous activities at a time in a quick, repetitive fashion (suc…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

771 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

11 Experts available now in Live!

Get 1:1 Help Now