1. Categories >> Software >> Data Warehouse >> Business Objects
  2. Suggest New Category

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 )

Question Posted / apurba

Answers were Sorted based on User's Feedback



I have two data providers with common dimension and measures. The only difference between two data ..

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

I have two data providers with common dimension and measures. The only difference between two data ..

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

I have two data providers with common dimension and measures. The only difference between two data ..

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

I have two data providers with common dimension and measures. The only difference between two data ..

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

I have two data providers with common dimension and measures. The only difference between two data ..

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

I have two data providers with common dimension and measures. The only difference between two data ..

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

Post New Answer

More Business Objects Interview Questions

Once the project is submited to the Client. Client says that report is taking long time to run? Where u need to check?

2 Answers   Wipro,

i have 2 fact and 2 dimension tables in my universe . my question is how get the data with two fact tables in a report?

4 Answers   Cap Gemini,

Hi friends How to design Xcelsius dashboard trough "SAP Netweaver connection" please explain steps for SAP Net weaver connection.

1 Answers  

I WOULD LIKE TO GO FOR ONLINE CERTIFICATION FOR BUSINESS OBJECTS 6X. CAN SOMEONE GIVE ME IDEA ABOUT. Thanks in advance

5 Answers   TCS,

I HAVE DRAGGED OBJECTS IN QUERY PANEL.... IF I CHECK THE SQL QUERY IT WAS SHOWING 2 QUERIES IN WHAT SITUATION IT WILL HAPPEN?

2 Answers   Accenture,

suppose case1:a person buy a car case2: rent a car which is context & which is alias? why?

2 Answers   IBM,

Explain what task is 98% of the required work of a business analyst?

1 Answers  

IF I WANT TO INSTALL BO ENTERPRISE PRODUCTS IN WINDOWS 2000 PROFESSIONAL SERVER ,WHAT SHOULD BE THE SYSTEM CONFIGURATION?

1 Answers   AG Technologies,

How to resolve the partial result error in the report

4 Answers   Keane India Ltd,

How can you check the universe?

3 Answers  

HOW TO SEND THE PARTICULAR REPORT DIVISION AND PARTICULAR USER?

2 Answers   Polaris,

Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.

1 Answers  

For more Business Objects Interview Questions Click Here
Categories