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
- 11198 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
In source system we have os - windows BO - 5.1.5. with webi 2.7.1 Repository database - oracle Reports database - Oracle and DB2 Nearly we have 1200 reports in present system , i want to move as it is to new hardware os- windows bo- 5.1.5 with webi2.7.1 repository - oracle reports - oracle and db2 let me know is there any migration techniques in same version. thanks in advance Usha
What is difference between webi and infoview?
Is there any other repository domains rather than universe, security, document?
Which command using Query Analyzer will give you the version of SQL server and operating system ?
Explain is it the job of a business analyst or systems analyst to draw the class diagram?
What is top business?
Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye
How can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
How to schedule the report in b.o?
What is the difference between slice and dice and cross tab report?
When we use aggregate awareness function in designer?
Can we configure two instances of CMS pointing to two different CMS system databases?
how many reports have u created ? explain a few.
Explain in detail about type 1?
What is object stores?
