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
- 7125 Views
- Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Can we Save (save as) WEBI Doc as DESKI?
where are objects are stored ?
What is the Difference b/w Server based Ranking and normal Ranking?
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:<servername>/olap/msmdpump.dll" I am using ms sql server 2012 -- cube
what is merged imension in 6.5 and webi
What is the difference between derived table and views? which one gives better performance?
what is a Micro cube?
i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?
Explain in Detail about Measure Objects? and what is the use of it? How to create it?
Explain the diff security levels of Private, Public, Controlled, Confidential, Restricted.
what is the difference between breaks and sections?
what is fantrap ?
Teradata 
