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 / 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 prepare the documentation in business objects and where to get the requirement?
What is the difference between absolute and relative div positioning?
What is the difference between the public object&schema object?
Can we create universe with no cache??
how to create reports on screech?
What is a fantrap in business objects?
What sort of existing documents should business analysts refer to when starting on a new project?
I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!
Explain what are the steps to do to use alerts in bo?
Can we Save (save as) WEBI Doc as DESKI?
Explain is it the job of a business analyst or systems analyst to draw the class diagram?
If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?
Explain what are the steps to be taken to schedule the report?
U r project in which stage in implementation?
What is the dense rank?