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..

Answers were Sorted based on User's Feedback



HI EVERYONE I HAVE A QUESTION I FACED A QUESTITON FROM INTERVIEWER IN WEBI REPORT CREATING CROSS..

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

HI EVERYONE I HAVE A QUESTION I FACED A QUESTITON FROM INTERVIEWER IN WEBI REPORT CREATING CROSS..

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

HI EVERYONE I HAVE A QUESTION I FACED A QUESTITON FROM INTERVIEWER IN WEBI REPORT CREATING CROSS..

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

HI EVERYONE I HAVE A QUESTION I FACED A QUESTITON FROM INTERVIEWER IN WEBI REPORT CREATING CROSS..

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

Post New Answer

More Business Objects Interview Questions

Explain the diff security levels of Private, Public, Controlled, Confidential, Restricted.

1 Answers   TCS,


What are the security level used in BO?

6 Answers   Oracle,


What is the user Object ? What is the need of it?

2 Answers   iGate, Infotech,


what is the difference between Ranking and sort-out in bo?

2 Answers   iNautix, TCS,


How do u Receive requiremnts from the client?

3 Answers  






What are templates? Explain what you have created?

1 Answers  


when will use compatible and incompatible objects?

1 Answers   Business Intelligence Analytics, iGate, TCS,


IN BO i have data source having the data like "abc" and after creating the Report on that datasource the data unmathed like "def".what will you do ? please anybody help me

2 Answers   Accenture,


How to create an popup in the WEBI report if the report is showing partial result?

2 Answers   Banking, IBM,


What is meant by ZABO and FC(full-client)?

2 Answers  


suppose case1:a person buy a car case2: rent a car which is context & which is alias? why?

2 Answers   IBM,


Can anybody explain me the following Authodications? Enterprise,LDAP,Standalone,Windows AD and Windows NT ?

1 Answers  


Categories