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 |
i want to take a report 10 records per page. How to take it? is there any paging option in BO?
how to solve #multivalue, #syntax, #error. iwant complete solution process in practical wise?
What is mean by stored procedure ? and how we can generate stored procedure universe?
filename would be GCP_ARS_BO_TM_BERT MMDDYYYYHH24MISS.xls. how to do it?
What are the types of errors you faced while creating a report from two different data providers
Can we start CMS server from CMC? Is yes can anyone tell me how plz Thanks in advance?
what is universe testing(not mention check integrity)
how to optimize the query perfomance in b.o?
How to create Generic TIME CLASS, which includes Objects Year,Month and Qtr?
What three things do you consider to be the most important factors for a manager?
What is the difference between user and versatile user?
how do we schedule reports in WEBI? i want to schedule 3 reports consicutively....how can i achieve this