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
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 |
what are the day to day activities of BO administrator ?
HOW YOU WORKED WITH MULTIPLE DATA SOURCES?IF YES ?HOW DO YOU LINK THEM?
what r the advantages of creating the universe?
when to go for alias and when to go for contexts
what is difference between WEBi Report and Crystal Report?
3 Answers Cognos, Nucleus Software, Red Cross,
every reports have docid,when i export a report docid will change or not?
Steps to create alias and apply
what is projection function in SAP BO
How to link one location universe to other location universe
what is universe
Iam having an report it contain n number of rows i want to desplay each rows in one colur pls explain me its very important
you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz