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
- 12214 Views
- Exilant, Siebel, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / manisha
Create 2 objetcs at Univ Level ,
Current fiscal year =
to_char( sysdate,'YYYY')
Previous Fiscal Year =
to_number(to_char( sysdate,'YYYY'))-1
Now in the DP for the current fiscal yr, pull Current
fiscal year , measures will be automatically be computed as
per the current fiscal yr.
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / gowthami
Create two objects in universe YEAR and YEAR-1
DP1:
Select panel: Other objects + Year +Year-1
Filter Panel: Year=prompt
DP2:
Select panel: Other objects + Year
Filter Panel: DP2.Year=(Use 'select object from another query') DP1.Year-1
Explanation:
DP1:
Assume that year=2014
Filter Panel: Year=(prompt) 2014
Select panel: Other objects + 2014(Year) +2013 (Year-1)
DP2:
Filter Panel: (DP2.Year) 2013 = 2013 (DP1.Year-1)
Select panel: Other objects + (Year) 2013
Since we take the year-1 from data provider 1 the DP2 will always give you the previous year data.
Thanks
Gowthami
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / 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 |
Answer / 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 |
Answer / 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 |
Answer / apurba
Thanks Anil, for your response. But I need to calculate
measures on the basis of dimensions which can't be done in
report level.
As per my requirement data needs to be calculated for two
different years.
| Is This Answer Correct ? | 0 Yes | 1 No |
IN THE REPORT I WANNA APPLY HYPERLINK FOR A CELL IN THE COLUMN/ROW HOW TO ACHIEVE THIS? EG: YEAR COLUMN : 2001,2002,2003,2004 I WANNA APPLY FOR 2001 ONLY
2 Answers Accenture, Rolta, TCS,
HI i have a table with 4 columns in back end like sales id, sales revenue, order id and order amt. Now i have created 2 prompts at query level 1st on sales id and 2nd on order id. Now if i run the report for 1st prompt it has to display sales id and sales revenue. Then if i run the report for 2nd prompt then it has to overwrite the table with Order ID and order amount. How you will handle this?
What is sdlc in bo?
What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
Explain what are the measure objects?
difference between web intelligence,crystal reports and desktop intelligents
how u restrict the values?to display 5 values insted of 10 values?
how to optimize the query perfomance in b.o?
what is diff between Decode and case ? Give some Example?
What are the Input and Output Context Operators.
how to create metric universe ?
How to link two different universes ?
Teradata 
