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 |
What is the report extension in webi and deski
How to view Public folder in Infoview for the Non-admin user? (normal user) What is the diff of working DEKI,WEBI in Infoview, and working as Individual start->Business Objects-> Deskto Intelligence, Web Intelligence.
11.what are the features in BO?
HOW TO PUBLISH A REPORT IN BO?
How many ways you can restrict data in business objects?
whats the Diffrerence between business objects and cognos?
What are the data types present in bo? What happens if we implement view in the designer and report?
can any one tell me how to create a new universe from scrach with step by step process.
@prompt('message',['type'],[lov],[mono/multi], [free/constraint]) what is Constraint?
U r project in which stage in implementation?
Explain the difference between union and group?
GENARALLY HOW MANY REPORTS ARE CREATE FOR EACH ONE ?PLZ EXPLAIN AFEW FOR AUTOMOBILE PROJECTS?