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
Answers were Sorted based on User's Feedback
Answer / 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 |
REGULAR CLASSES for Hyperion Financial Management+ODI+HFR+FDQM is Starting From Sunday, 23th Oct, 7:00 AM IST.
Explain how many universes can be created in a project?
What problems you have faced while creating an universe? tell me an incident and how you went about solving it?
What is sdlc in bo?
how to solve the incompatible objects and how they are formed actually.
what is prompt? Cascading prompt? Syntax
what is dashboards? what is metrics?
I have scheduled a weekly report to client. If the data is Over which client wanna receive what will happen?
What is security domain in Business Objects?
CAN WE CREATE VIEW IN BO (NOT DERIVED TABLES)?
Explain what is the difference between slice and dice and cross tab report?
Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com