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 performance tunning in BO in report level& designer level?
WHAT IS CARDINALITY?
how to improve the performance of the report
Suppose we had a scenerio like in an universe there are nearly 250 objects but only 50 objects data is updated frequently so is there any way to overcome it.(Birla Soft,)
While at local system, u could get all records say 1 lakh, but while at server u got only 50000 records when u run the report. What could be the causes. How to Rectify this.
What are the general issues in migration process?
When is the Repository created?
WHAT IS CARDINALITIES OF JOIN?
What is Cartesian product?
In banking domain how many Fact tables,Dimension table are present?
How to create a Pop-up in BOXIR2. Ex:- A class is having an object as "AGE", whenever this object is used in the reporting level automatically a pop- up will be coming which shows a prompt as "Please use the object DOB".
how to do scheduling in desktop intelligence in BO XI R2