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 |
Explain the diff security levels of Private, Public, Controlled, Confidential, Restricted.
What are the security level used in BO?
What is the user Object ? What is the need of it?
what is the difference between Ranking and sort-out in bo?
How do u Receive requiremnts from the client?
What are templates? Explain what you have created?
when will use compatible and incompatible objects?
1 Answers Business Intelligence Analytics, iGate, TCS,
IN BO i have data source having the data like "abc" and after creating the Report on that datasource the data unmathed like "def".what will you do ? please anybody help me
How to create an popup in the WEBI report if the report is showing partial result?
What is meant by ZABO and FC(full-client)?
suppose case1:a person buy a car case2: rent a car which is context & which is alias? why?
Can anybody explain me the following Authodications? Enterprise,LDAP,Standalone,Windows AD and Windows NT ?