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
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 |
what is slice & dice?
3 Answers Cognizant, Saama Tech, TCS,
When N reports are scheduled for N users, How does the BCA process /know to which user the report needs to be sent?
How do you find what type of trap is there by seeing the report?
1. 101 vinay hyderabad 123 naresh usa 152 singh delhi 101 vinay usa 123 naresh mumbai 156 raju chennai From the above data we need to retrive current data in a report ? how and explain in detail ?
Hi ,how many shortcut joins used in a single universe? Thanks in Advance
What are all difference between business objects 6.5 and xi r2?
How can you first report in Business Objects by using broadcast agent?
0 Answers Ness Technologies, Wipro,
draw the architecture of bo
Pls Explain about the different between 6.5 & Xi R2
Where will you find the address of repository in Business Objects?
is there any limit for rows and columns in cross tab
what is the difference between Ranking and sort-out in bo?