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
- 7752 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
How to schedule the report in b.o?
Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
What sort of existing documents should business analysts refer to when starting on a new project?
BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...
i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?
Explain what three things do you consider to be the most important factors for a manager?
What are the steps to be taken to schedule the report?
Explain how to schedule the report in b.o?
How were the reports scheduled and how to resolve unexecuted documents?
How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes
Explain what task is 98% of the required work of a business analyst?
Explain what is the difference between business requirement document and use case document.
How would you format some text using css to be verdana and bold?
Explain the difference between detect alias and detect context?
How to execute the plsql procedure from the report by clicking with mouse?
