on 08-02-2012 10:37 AM
Hello,
i'm facing following problem in my webi file.
--> XI 3.1
I've got two reports:
Example for execution with a Keyfigure in Quarter 1 2012:
2012-W1 2012-W2 2012-W3 .... 2012-W12
KYF xxxxx xxxxx xxxxx xxxxx
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.