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

  1. Categories >> Software >> Data Warehouse >> Business Objects
  2. Suggest New Category

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

Question Posted / arjunreddy

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


Please Help Members By Posting Answers For Below Questions

can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?

1431

Differences between business objects and web intelligence reports?

1295

Is there any other repository domains rather than universe, security, document?

1087

how to prepare the documentation in business objects and where to get the requirement?

2278

Explain what is aggregate table and aggregate fact table ... Any examples of both?

1144

Explain what three things do you consider to be the most important factors for a manager?

1051

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

1915

is it possible to export the webi reports to crystal reports?with out using businessview?

2346

Explain is data mart?

1068

What Is Snow Flake Schema?

1252

How can you first report in Business Objects by using broadcast agent?

3100

Explain how can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?

1135

Explain how many universes can be created in a project?

1109

What is a fantrap in business objects?

1224

Can we Save (save as) WEBI Doc as DESKI?

8286