My data source is Excel sheet. How to write the SQL
Statement for Excel file in data provider? Is is possible?
Answer Posted / guest
use personel data provider and use this excel to get the
data. Automatically it will create the SQL from excel.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What is the profile and package?
Explain when we use aggregate awareness function in designer?
What would you consider as your biggest achievement and why?
Its regarding Javascript coding for customization in BI4 reports. We need to have all the options disabled in the report except the option to Export(save the report in computer in Excel/pdf formats). I am able to hide TopBar,TabBar,Left Navigation etc but I need "Export" option to be displayed to the users in Read mode. Can this selective "hiding" be achieved?
What is the difference in creating filters in designer and business objects?
Can you please send me the migration related issues .
In banking domain how many Fact tables,Dimension table are present?
any difficulitis have you phase while creating bo reports and how did u solve it
Explain what is the difference between slice and dice and cross tab report?
Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye
Explain how can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
What are the steps to be taken to schedule the report?
Explain when to use local filter and when to use global filter?
Explain the difference between union and group?
What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?