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
What is top business?
Explain about a task that really tested your analytical abilities?
Is there any other repository domains rather than universe, security, document?
Explain what sort of existing documents should business analysts refer to when starting on a new project?
Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
What is the difference between business requirement document and use case document.
If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?
What is object stores?
Explain is there any default username & pwd for bo designer & supervisor?
If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?
Explain what are the steps to be taken to schedule the report?
what is the difference b/w the refresh and buffered data?
Can we Save (save as) WEBI Doc as DESKI?
Explain what are the steps to do to use alerts in bo?
What are the data types present in bo? What happens if we implement view in the designer and report?