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 difference between global filter an query filter in web intelligence?
can anybody tell me about complicated object you have created
what is fantrap and chasmtrap ?
what is master-detail report
How to create Index to the table in the universe designer and how it improves the Query performence
i am facing date format issue in webi report in BI4.0 environment. i have unx based on Mysql connection. date is coming in 10 digits numeric format like(2345623456). I want to change it in dd.mm.yyyy format. Please suggest
explain about Prompt with example?
What is the difference in creating filters in designer and business objects?
how to creat 2 way drilling mode.can any one know this
Can We customize the Business Object infoview in BO?
How many universes will run maximum in single project
What are the security level used in BO?