Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 12402 Views
- Exilant, Siebel, I also Faced
- E-Mail Answers
Answer Posted / bibin
edit sql in dataprovider ,
Date >= add_months(date),-12
and then check "do not generate sql before running" option.
regds
bibin
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
what are the tables used in health care domain project and columns used in report?
What is the difference between datawarehousing and businessintelligence?
Explain when to use local filter and when to use global filter?
Explain what sort of existing documents should business analysts refer to when starting on a new project?
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?
What task is 98% of the required work of a business analyst?
Can more than 1 metric be applied on an analytic in business objects?
Differences between business objects and web intelligence reports?
Explain about a time when you discovered a more efficient way to do a work task?
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 ?
How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes
how to prepare the documentation in business objects and where to get the requirement?
How to execute the plsql procedure from the report by clicking with mouse?
How can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
Is there any other repository domains rather than universe, security, document?
