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
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
Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.
How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)
What is object stores?
What is the difference between user and versatile user?
Can we configure two instances of CMS pointing to two different CMS system databases?
Explain in detail about type 1?
Explain what task is 98% of the required work of a business analyst?
Explain when to use local filter and when to use global filter?
what is the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?
How would you format some text using css to be verdana and bold?
Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?
What Is Snow Flake Schema?
When we use aggregate awareness function in designer?
Explain is data mart?
Can you please send me the migration related issues .