Interested to Buy Any Domain ? << Click Here >> for more details...
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..
- 4 Answers
- 11349 Views
- IBM, I also Faced
- E-Mail Answers
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
Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
Which versions are used in the bo dashboard work?
Which command using Query Analyzer will give you the version of SQL server and operating system ?
Give some information on report bursting?
What Is The Difference Between Oltp And Olap?
What are the steps to do to use alerts in bo?
When we use aggregate awareness function in designer?
How to open a universe with out using the Designer ??
What is the functional & architectural differences between business objects and web intelligence reports?
how to create reports on screech?
What is report template in b.o?
can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?
How to sort the dynamic objects alphabetically on the Universe based on and SQL Server
What are the data types present in bo? What happens if we implement view in the designer and report?
Explain about alerts in bos, under what situation we need to use alerts?
