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
- 11546 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sami
use where clause in the function bar, or 2nd method is to
create a new variale and put a filter by showing the data
for particular months
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / 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 |
Answer / vips
there is value based Break available in webi apply value based break at month no 3
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / tim
You need to create a universe based date dimension object
based on the column's date and then apply the Quarter
function (or DBMS vendor equivalent) in order to split the
values of the LOV up into Quarters. Once you can see the
date values in quarters, simply section break the webi
report using your newly created dimension.
| Is This Answer Correct ? | 2 Yes | 3 No |
How can we use multiple data providers in a single report in business objects?
What is the pragma?
Tell me a business scenario where I can achieve the data through MINUS only not through subquery.
what is crystal reports?how to migrate them?
main purpose of aggregate awareness(not include make possible of use of aggregate tables)
1.what is the functionality of "Event Server" in BOXIR2? 2.what happen if RAS server is down in BOXIR2
How maually can i define ? If thousends of records exists in a table?
What is diff between InfoView and Zero BOAdmin (ZABO)?
IN WHICH DIFFERENT SCENARIOS WE CAN USE @AA FUNCTION?
filename would be GCP_ARS_BO_TM_BERT MMDDYYYYHH24MISS.xls. how to do it?
if we shortcut join between two tables what will be the output?that it will give all columns or same columns?
1. can we create report using multiple universes and how ? 2. how can we move the objects from universe A to universe B in report ? 3. how can we create aggregate table at universe level ? 4. if there is only one fact table in that universe, what happens if we get fan trap ?
Teradata 
