I have the one Universe. I take the data from the Excel
Sheet. Now i want to get the reports from the two.What is
the process
Answer Posted / v.sivakumar
We should have two data provider in this case,
One dataprovider which contains the data from universe and
other dataprovider which consists of the excel sheet data.
after excuting it , merge the common dimension on both the
dataprovider and generate the report.
| Is This Answer Correct ? | 12 Yes | 0 No |
Post New Answer View All Answers
Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
Explain difference between zabo and webi?
When to use local filter and when to use global filter?
What is the profile and package?
how many reports have u created ? explain a few.
If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?
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
When we use aggregate awareness function in designer?
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 ?
Explain what task is 98% of the required work of a business analyst?
Explain about a tricky situation for which you found a very simple solution?
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...
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
can anybody tell me about complicated object you have created
Explain how to execute the plsql procedure from the report by clicking with mouse?