cancel
Showing results for 
Search instead for 
Did you mean: 

Two different restrictions in two reports in one webi file? How to?

Former Member
0 Kudos

Hello,

i'm facing following problem in my webi file.

--> XI 3.1

I've got two reports:

  • The first one displays a keyfigure in a weekly order (Calyear/week) for current month.

         Example for execution with a Keyfigure in Quarter 1 2012:

        2012-W1   2012-W2   2012-W3 ....   2012-W12

KYF     xxxxx          xxxxx         xxxxx                xxxxx

  • The second one displays a keyfigure in quarter order (Calyear/quarter), starting after current quarter for next 3 years..

   Example for execution with a Keyfigure in Quarter 1 2012:

  2012-Q2   2012-Q3   2012-Q4   ...   2014-Q1

KYF     xxxxx          xxxxx         xxxxx                xxxxx

What do I have to change and where. A colleague who is unfortunately not available at the moment told me I can develop it WebI itself. But I couldn't make it.

I would be very grateful if someone could help me.

Thanks and Best Regards.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi

For First Report

U have to select measure, Week Object ,at query level and at query filter add the quarter object and selct prompt and run the report . U will display select quarter ,select from list  ,Click ok

At report level

Take a cross tab which is under templates, and drop in report body . At column header drag and drop week object , at row header just hard code KFY as u mentioned above and drag and drop measure in the cross tab body.

For Reprt two

Same  as above but small change is at query filter add year object and select operator greater than and give prompt

At report level

Create a varible for restricting next 3 years and create a formula like

Var_1

=year where (year>=userresponse("Enter year") and year<= userresponse("Enter year")+3)

Note: This might gives u error then u have to use tonumber function in where condition

var_2

=if  isnull(var_1 ) then "Other years" else Var_1

click on report filter and add var_2 not equal to "Other years"

now u can create a cross tab same i said above in report 1

Hope this helps u

Regards

Sunil

Former Member
0 Kudos

Thanks a lot for your response sunil!

Does this mean it can be handled in WebI itself without changing the universe?

Former Member
0 Kudos

Hi

Yes , we can do at report level, But for the second report ,there will be a performance degradation at report level becoz it takes all the years which are above the current year data,so unnecessary data also dump in report ,

My suggestion is for second report you can create a filter by using prompt function and filter upto 3 years  at universe level. ,and use that object at webi report . so that u will get data which u require

Hope this helps u

Regards

Sunil