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

What is top business?

0 Answers  


Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?

0 Answers  


I have 2 tables. Table 1 is employee table and Table2 is department table. In employee table i have 1,2,3,4,5 emp id's,in Dept table i have various dept's like a,b,c and i have 2,3,4 emp id's in my dept table.I joined with these 2 tables.I want the results for equi join means how many records will fetch.In the same scenario i have to know the left outer join, right out join and full outer join resuls means how many records will come. can any body tell me the answers

1 Answers   IBM,


There is one report running and a user wants to know whether data is from detail table or summary table. what is your approach?

1 Answers  


What is maximum number of promts we can give in a BO report?

1 Answers   Patni,






Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?

0 Answers  


what are the roles and responsibilities of BO Administrator ?

1 Answers   OCS Infotech, TCS, Wipro,


What is the Computation error? how to solv it?

1 Answers  


What is a category?

3 Answers  


Explain about MTD(Month To Date) and YTD(Year To Date) with one example and where you use this in your project?

2 Answers   TCS,


Regarding Hyperlinking in Business Objects. We have a few reports in QA environment where a number of hyperlinks are employed using OpenDoc function.In some of the reports,hyperlink is used to move to another tab within the same report.The formula used include "DocID" and ReportName="tab name".This works fine but now,for the PROD move,this will not work as the Doc Ids are subject to change. Is there a way to overcome this?Without DocID,how will move to a particular tab? Thanks in advance

1 Answers  


What are the diffrences between Business Objects 5.1 & 6.5 ?

1 Answers   Siemens,


Categories