HI EVERYONE
I HAVE A QUESTION I FACED A QUESTITON FROM INTERVIEWER
IN WEBI REPORT CREATING CROSS TAB REPORT FOR EX: YEAR IS
COLUMN WISE AND MONTH IS ROW WISE AND INTERSECTIO IS
REVENUES . HE WANTS BREAKS AT FIRST 3 MONTHS IN ROW LEVEL
.. COULD U PLEASE TELL ME IF ANYONE KNOWS..
Answer Posted / arjunreddy
first we have to create one variable like quarter based on month
Quarter :: if((<month>) inlist ("1","2","3") then "Q1" ElseIf((<month>) inlist ("4","5","6") then "Q2"
ElseIf((<month>) inlist ("7","8","9") then "Q3"
ElseIf((<month>) inlist ("10","11","12") then "Q4" Else <Month>
then we can apply break function on quarter.
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What are the join problems comes appart from loop,chasm & fan Traps
What sort of existing documents should business analysts refer to when starting on a new project?
Did you face any problems while creating reports? Name? Solutions?
How to generate the report from excel sheet?
What three things do you consider to be the most important factors for a manager?
Explain how we drill up week to month?
What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?
What is the difference between business requirement document and use case document.
What are the data types present in bo? What happens if we implement view in the designer and report?
Can you please send me the migration related issues .
Is there any other repository domains rather than universe, security, document?
In banking domain how many Fact tables,Dimension table are present?
If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?
any difficulitis have you phase while creating bo reports and how did u solve it
8. How much supervision have you typically received in your previous job?