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 |
when you have three fact table and there is no relationship between them. How you will tackle the issue.
What are the Errors in BO Pls Explain with Examples
2 Answers iFlex, Tech Mahindra,
Can we start CMS server from CMC? Is yes can anyone tell me how plz Thanks in advance?
what is the difference b/w the refresh and buffered data?
why you create universe and creating reports based on that? why dont we go for crystel reports and generate reports directly?tell me the advantages?please answer to this question.
what is dashboards? what is metrics?
Suppose i have the sinario like this column1: e1,e2,e3,e4 : column2: 1,0,1,0 : column3: M,F,M,F : in this i want to disply 1 is male and 0 is female which is added to the another column like column 4 what is the process?
Explain which versions are used in the bo dashboard work?
WHAT IS CARDINALITY?
How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)
0 Answers Banking, Genpact, TCS,
if the project is assigned for you and the client said yo wait for a month,What will you do in that time?
HOW TO EXPLAIN SHORT CUT JOIN AND THETA JOIN?