Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 7792 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 and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?
Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
In banking domain how many Fact tables,Dimension table are present?
What is a fantrap in business objects?
I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!
how to create reports on screech?
If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?
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
Explain how can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
What is the difference in creating filters in designer and business objects?
What is the difference between condition & filter?
What is difference between custom hierarchy and report based hierarchy?
How to restrict password to a user while sending a document in .pdf format
please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.
What are the data types present in bo? What happens if we implement view in the designer and report?
