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..
Answer Posted / 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 View All Answers
Explain what task is 98% of the required work of a business analyst?
Explain difference between zabo and webi?
What is the difference in creating filters in designer and business objects?
1)I have createcd a dashboard on Bex query. How to refresh the Dashboard without hitting the bex query? 2)What is Event based scheduling in BO? 3) How to display the BO webi report title using a function? 4) For eg in my webi report iam having a person name like Jhon Peter Adam. But i need to get only the middle name of the person like Peter. What function is used in Webi to get this?
Its regarding Javascript coding for customization in BI4 reports. We need to have all the options disabled in the report except the option to Export(save the report in computer in Excel/pdf formats). I am able to hide TopBar,TabBar,Left Navigation etc but I need "Export" option to be displayed to the users in Read mode. Can this selective "hiding" be achieved?
what is xcelsius architecture?
How to restrict password to a user while sending a document in .pdf format
What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?
how to prepare the documentation in business objects and where to get the requirement?
If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?
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)?
any difficulitis have you phase while creating bo reports and how did u solve it
What is the functional & architectural differences between business objects and web intelligence reports?
Differences between business objects and web intelligence reports?
Explain the data types present in bo and what happens if we implement view in the designer and report?