Interested to Buy Any Domain ? << Click Here >> for more details...
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..
- 4 Answers
- 11215 Views
- IBM, I also Faced
- E-Mail Answers
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
How to restrict password to a user while sending a document in .pdf format
Can anybody tell me what are the tuning problems?
How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes
Explain about a task that really tested your analytical abilities?
Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.
Explain what is the difference between slice and dice and cross tab report?
Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye
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?
How to generate the report from excel sheet?
what is the difference b/w the refresh and buffered data?
Explain about alerts in bos, under what situation we need to use alerts?
hi all of u, i want to learn the course in SAP(BI).because of there is no calls for BO. And the another region is it will be converted into SAP module. is it OK for me? is there any feauture in coming days? could any one plz send me the message
What Is The Difference Between Oltp And Olap?
how many reports have u created ? explain a few.
When to use local filter and when to use global filter?
