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
- 7897 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
Which versions are used in the bo dashboard work?
I have set of reports in BO4.0 and need to use "Hyperlink" functionality. I had to use native hyperlink functionality provided in BO4.0 but looks like it's available only in Rich Client.Currently,we have only Infoview B04.0 Launch Pad.Is OpenDoc the only hyperlink option on BO4.0 Launch Pad? Thank you.
How to generate the report from excel sheet?
What is the dense rank?
What are all difference between business objects 6.5 and xi r2?
What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?
Can we configure two instances of CMS pointing to two different CMS system databases?
please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.
Explain when we use aggregate awareness function in designer?
Explain how many universes can be created in a project?
How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.
Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...
How to restrict password to a user while sending a document in .pdf format
Hi, I would like to know how is the integration if we want to use Oracle Essbase as the Cube Engine, and present the Cube by Business Objects Presentation Layer? Can Oracle Essbase be integrated with Business Objects? Thanks,
Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?
