Crystal reports updating from spread sheet
Below is an example of a table in which the former V and W rows have been moved to the A and B column positions.
Hellow Experts I am trying to load/import excel data into bobj, I am wondering which appraoch is the best and what are the pros and cons of these approaches.
The spreadsheet returns, filtered by values greater than 10.
We just deployed bobj 4.1 sp01Approach 1: Build universe based on excel datasource and then build webi query Approach 2: Import excel file directly into webi I would appreciate if you advise the following.1.
What is the refresh machnaism in both these approached2.
Any changes you identify could then be manually updated in the scheduling system.
Downloading your query results into an Excel spreadsheet is a good way to provide yourself with a quick reference document.
NOTE: You can add a query to your favorites list for quick navigation to the queries you run frequently. When you select Run to HTML or Run to Excel, an interface appears displaying fields for entering search criteria.
If your computer blocks pop-ups, you may be prompted by the browser to approve the download. Do not select the Run to Excel option if Excel is not installed on your computer.
Oracle Crystal Ball is the leading spreadsheet-based application for predictive modeling, forecasting, simulation, and optimization.
It gives you unparalleled insight into the critical factors affecting risk.
However, you may not require all of the data that automatically appears in the spreadsheet upon download.
Here are some suggestions to help you refine your take-away document.
What is the best suitable file format for this kind of data load into bobj, I have following file format, please see attachment cell hielighted in yellows are dimension and green are measures) can you please let me kow if this format is correct.Tags: Adult Dating, affair dating, sex dating