Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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 )

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


Please Help Members By Posting Answers For Below Questions

Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?

1036


Can Bo generates the Report from the cubical data Explain?

2032


What are the steps to do to use alerts in bo?

1394


What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?

2906


What is the difference between slice and dice and cross tab report?

1041


webI report not showing Barcode in PDF format, i have used BC39 font,but barcode is shown in HTML but not in PDF, please any solutions??

4404


Explain how we drill up week to month?

1092


What is the functional & architectural differences between business objects and web intelligence reports?

2410


CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN

2154


BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...

2166


How to restrict password to a user while sending a document in .pdf format

2341


If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?

1018


Explain 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)?

1060


how many reports have u created ? explain a few.

2083


Can we create universe with no cache??

2505