Sign Up Login


  1. Categories >> Software >> Data Warehouse >> Business Objects
  2. Suggest New Category

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

Question Posted / gowthami

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


Please Help Members By Posting Answers For Below Questions

what is document design in boxi,have u participate in that

1827

How to generate the report from excel sheet?

815

What is the difference between user and versatile user?

749

IN THE REPORT I WANNA APPLY HYPERLINK FOR A CELL IN THE COLUMN/ROW HOW TO ACHIEVE THIS? EG: YEAR COLUMN : 2001,2002,2003,2004 I WANNA APPLY FOR 2001 ONLY

9786

When to use local filter and when to use global filter?

761




What is object stores?

746

What Is Snow Flake Schema?

864

What are all difference between business objects 6.5 and xi r2?

777

webI report not showing Barcode in PDF format, i have used BC39 font,but barcode is shown in HTML but not in PDF, please any solutions??

4130

Explain is there any other repository domains rather than universe, security, document?

742

U r project in which stage in implementation?

2164

Hi friends, I am trying to create OLAP connection in IDT. I am getting error "error code:405 METHOD NOT ALLOWED" I am using "http:/olap/msmdpump.dll" I am using ms sql server 2012 -- cube

3540

What is the difference between slice and dice and cross tab report?

809

How to execute the plsql procedure from the report by clicking with mouse?

790

Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com

2163