Interested to Buy Any Domain ? << Click Here >> for more details...
My data source is Excel sheet. How to write the SQL
Statement for Excel file in data provider? Is is possible?
- 3 Answers
- 9271 Views
- TCS, I also Faced
- E-Mail Answers
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
Then how to select the source by using webi or deski reports into crystal reports? i think main source is Businessview. where u import the datasource ?
BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...
(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.
i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?
Give some information on report bursting?
What Is Snow Flake Schema?
What is the difference between datawarehousing and businessintelligence?
how to create metric universe ?
Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?
Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?
Explain how many universes can be created in a project?
Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
What is the difference between absolute and relative div positioning?
Tell me a business scenario where I can achieve the data through MINUS only not through subquery.
what are the day to day activities of BO administrator ?
