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
- 11399 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
Can we create universe with no cache??
Give some information on report bursting?
What is the difference between slice and dice and cross tab report?
Explain what is the difference between business requirement document and use case document.
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
What is package in BO
What is the difference between the public object&schema object?
1)I have createcd a dashboard on Bex query. How to refresh the Dashboard without hitting the bex query? 2)What is Event based scheduling in BO? 3) How to display the BO webi report title using a function? 4) For eg in my webi report iam having a person name like Jhon Peter Adam. But i need to get only the middle name of the person like Peter. What function is used in Webi to get this?
What are all difference between business objects 6.5 and xi r2?
I have set of reports in BO4.0 and need to use "Hyperlink" functionality. I had to use native hyperlink functionality provided in BO4.0 but looks like it's available only in Rich Client.Currently,we have only Infoview B04.0 Launch Pad.Is OpenDoc the only hyperlink option on BO4.0 Launch Pad? Thank you.
Explain about a tricky situation for which you found a very simple solution?
What is the difference in creating filters in designer and business objects?
Explain what are the steps to do to use alerts in bo?
any difficulitis have you phase while creating bo reports and how did u solve it
What is a bo repository?
