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.

Is it possible to create a new calendar using BO? Ex:- Wants to create a calendar where the year starts with the 1feb - 25Feb. Next month from 26Feb - 14Mar.

1 Answers  

Why do we need metrics and sets?

1 Answers  

I need to modify Web Intelligence Report, I need to Add 7 columns in WEBI Report-Java Pannel, so i could Add only 6 Columns in the Webi-Java Pannel as one X Table - X Column is not available in the Universe. I was advised that i can do it with Free Hand SQL in Web Intelligence even X Table - X Column is not available in Universe. Please kindly let me know how to implement the same

2 Answers  

If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?

0 Answers  

Hi Can anyone tell me what is Divergence in Business Object Universe Designer. Thanks, Sheik

1 Answers  

1.How to convert deski document to webi in infoview? 2.what is connection type for free hand sql?

3 Answers   Wipro,

can we create aliases for every table beforehand? if yes whar are the disadvantages?

5 Answers   AG Technologies,

Shall we connect to the oltp systems directly .,

2 Answers   iNautix,

What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?

0 Answers   Infosys,

What is meant by multiple data provider.How to use it in universe as well as reporting environment?

6 Answers   TCS,

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

5 Answers   HCL,

what is the syntax for aggregate awareness?

3 Answers   Exilant, i-Tree, Wipro,