Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 3 Answers
- 7636 Views
- Wipro, I also Faced
- E-Mail Answers
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
CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN
Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
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
What three things do you consider to be the most important factors for a manager?
Explain about a time when you discovered a more efficient way to do a work task?
Is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
How were the reports scheduled and how to resolve unexecuted documents?
Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye
Differences between business objects and web intelligence reports?
what is document design in boxi,have u participate in that
Can we Save (save as) WEBI Doc as DESKI?
Then how to select the source by using webi or deski reports into crystal reports? i think main source is Businessview. where u import the datasource ?
What is aggregate table and aggregate fact table ... Any examples of both?
what are the day to day activities of BO administrator ?
Can we create universe with no cache??
