Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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..

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

I am trying to save the XI report to CSV format. the csv file not displaying columns in order. all the columns are misplaced. the report size is 12MB Can any one tell me why the columns are incorrect position when XI report converted into CSV format?

3 Answers  


If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?

0 Answers   iNautix, Wipro,


What is the report extension in webi and deski

2 Answers  


How to link two different universes ?

3 Answers  


in BO module, you forgot all password even all user in business object, designer, supervisor, gen.supervisor everythicg, how to you recover your datas?

1 Answers   iFlex,


how to link 3 fact tables

1 Answers  


Tell me about linked universe ?

5 Answers   Tech Mahindra,


What is metrics?

2 Answers  


How many universe dfi you create if you have 2 years of experience in BO

6 Answers   IBM,


. In production reports, some dimensions are missing. how do you load these dimensions in production

2 Answers   TCS,


Explain difference between zabo and webi?

0 Answers  


wat is report linking in BO..I know that 2 reports can be linked in BO with the help of writing a HTML code .But how. wat s the code.can u give me the example of code taking e fashion as the simple univers data provider.

2 Answers   Accenture,


Categories