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 )
- 6 Answers
- 10098 Views
- Exilant, Siebel, I also Faced
- E-Mail Answers
Answer Posted / swati
In case, your requirement doesn't allow you to create the
new objects at Designer level or use hard coded SQLs, then
you can try to create a prompt in the second dataprovider
named as 'Prev. Year'. When refreshing the report you can
pass the values for current and prev yrs both.
If you do not have a predefined filter for prev yr then you
can use your objects to create the similar conditions as
there are in the filter.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes
1)I have createcd a dashboard on Bex query. How to refresh the Dashboard without hitting the bex query? 2)What is Event based scheduling in BO? 3) How to display the BO webi report title using a function? 4) For eg in my webi report iam having a person name like Jhon Peter Adam. But i need to get only the middle name of the person like Peter. What function is used in Webi to get this?
1. 101 vinay hyderabad 123 naresh usa 152 singh delhi 101 vinay usa 123 naresh mumbai 156 raju chennai From the above data we need to retrive current data in a report ? how and explain in detail ?
Can you please send me the migration related issues .
Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?
Explain when we use aggregate awareness function in designer?
What is a fantrap in business objects?
U r project in which stage in implementation?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
What is report template in b.o?
Explain when to use local filter and when to use global filter?
What is the difference between absolute and relative div positioning?
What is object stores?
What is top business?
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
