I have two data providers with common dimension and
measures. The only difference between two data providers is
in condition 'Fiscal Year'.One data provider calculates for
current year and other one calculates for previous year. So
in prompts if I am passing 2008 as current year then the two
data providers should be able to calculate for current year
and previous year individually.
So Can anybody tell me how to do calculation in data providers.
( I am using BO WebI report )
Answer Posted / anil
Instead using two dataproviders for present and previous
year, why don't you use a formula previous(year dimension)
and calculate in report with single data provider?
| Is This Answer Correct ? | 3 Yes | 4 No |
Post New Answer View All Answers
Explain the data types present in bo and what happens if we implement view in the designer and 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
What is the difference between user and versatile user?
In banking domain how many Fact tables,Dimension table are present?
8. How much supervision have you typically received in your previous job?
What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?
How would you format some text using css to be verdana and bold?
Explain about a time when you discovered a more efficient way to do a work task?
If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?
What is the difference between slice and dice and cross tab report?
Explain what is the difference between business requirement document and use case document.
If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?
is it possible to export the webi reports to crystal reports?with out using businessview?
What are the join problems comes appart from loop,chasm & fan Traps
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...