In a Webi Report, Once u r entering a month name,it
displays the that month details and after and before month
details.How it is
- 3 Answers
- 6675 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / gowthami
DB table:
Month Cost
Feb 10
Mar 20
Apr 30
May 40
Consider you have month object and create a two objects at universe level month-1 and month+1
At report level
Query 1
Result objects: Month and cost Filter: Month prompt (Apr)
Output:
Month Cost
Apr 30
Query 2:
Result Obj: month+1 and cost filter Month =(select from another query)Month<from query1>
Output:
Month Cost
may 40
Query 2:
Result Obj: Month-1 and cost filter Month =(select from another query)Month<from query1>
Output:
Month Cost
Mar 20
When it is coming as output in a report
Output at the report: (use union in between the queries)
Month Cost
Mar 20
Apr 30
May 40
Hope this helps.. Try this and let me know. Currently I don’t ve BO axis (universe and webi). But we tried this logic in my last proj
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
explain in detail about type 3?
What is the profile and package?
Explain in detail about type 2(scd),
What is object stores?
how to create reports on screech?
In source system we have os - windows BO - 5.1.5. with webi 2.7.1 Repository database - oracle Reports database - Oracle and DB2 Nearly we have 1200 reports in present system , i want to move as it is to new hardware os- windows bo- 5.1.5 with webi2.7.1 repository - oracle reports - oracle and db2 let me know is there any migration techniques in same version. thanks in advance Usha
How to generate the report from excel sheet?
Can Bo generates the Report from the cubical data Explain?
Explain what three things do you consider to be the most important factors for a manager?
How would you format some text using css to be verdana and bold?
How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?
U r project in which stage in implementation?
IN THE REPORT I WANNA APPLY HYPERLINK FOR A CELL IN THE COLUMN/ROW HOW TO ACHIEVE THIS? EG: YEAR COLUMN : 2001,2002,2003,2004 I WANNA APPLY FOR 2001 ONLY
What is the difference between user and versatile user?
Explain is there any default username & pwd for bo designer & supervisor?
