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
in sap bi we have wad, then why we go for sap bo
how many reports have u created ? explain a few.
Explain what is aggregate table and aggregate fact table ... Any examples of both?
Explain what sort of existing documents should business analysts refer to when starting on a new project?
Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
what is the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?
In banking domain how many Fact tables,Dimension table are present?
What Is Snow Flake Schema?
Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
What is Indexing? how did u implement indexing?
What is the difference between the public object&schema object?
Can you please send me the migration related issues .
Explain the data types present in bo and what happens if we implement view in the designer and report?
Explain what task is 98% of the required work of a business analyst?
CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN