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.

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

Answer / bibin

edit sql in dataprovider ,

Date >= add_months(date),-12

and then check "do not generate sql before running" option.

regds

bibin

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.

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?

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.

1. What is the difference between in creating filters in designer and business objects? 2.How did u give a developed universe to your client? 3.If i want to grant access to a report to a group of users,how do i do?

2 Answers  

How many tables can an universe contain is their any limit to insert tables in the universe?

3 Answers  

HOW TO CREATE THE HEIRARCHY IN WEBI OR DESKI NOT IN UNIVERSE LEVEL?

5 Answers   HCL,

Explain the BO Developer WORK FLOW?

3 Answers   TCS,

How to create a tooltip in Webi? Is there a way to create Tooltips in Webi reports for non- hyperlinked columns? Users should be able to hover over a value in a column in the report and that should show a tooltip box with more detail regarding that column value. This is possible when you hyperlinked the column,Is it possible when you dn't have hyperlinking? Thanks in advance.

1 Answers  

How to import BIAR file in bo?

1 Answers   Emirates, Zensar,

in xir2 how to send reports to end user

2 Answers   TCS,

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

1 Answers  

I have a report with some hyperlinks,any issue will i get when i migrate this report?

1 Answers   Zensar,

how to optimize the query perfomance in b.o?

1 Answers   TCS,

why you create universe and creating reports based on that? why dont we go for crystel reports and generate reports directly?tell me the advantages?please answer to this question.

7 Answers   Satyam,

wat is the difference between full clinet report and thin client report?wat is the difference between desktop intelligence and web intelligence?

3 Answers   Target,