Dear Gurus,
I have two issues in OBIEE. I am using OBIEE 11.1.1.7.
ISSUE 1: I am using a report and the requirement is to make the "MONTH" column VERTICAL and at CENTER .
What I have Done:- I have used HTML CSS tags to achieve this: "transform: rotate(180.0deg); vertical-align:middle; text-align: center;Writing-mode: tb-rl; filter: flipv fliph;" (as in below image)
But, the problem is I am either able to make it at CENTER or am able to make it VERTICAL and not both at the same time (for JUN-17, JUL-17 and OCT-17, it is right-aligned).
My questions are as below:
a. Is there any simpler way to achieve this?
b. Also, this setting is working fine only in MOZILLA and not on CHROME or IE. What should I do for this to work on other browsers as well?
ISSUE 2: In this, we have received a requirement where we have to show the dimensional column (Project Number) in place of measures in Pivot view.
The requirement is to segregate the Project Numbers as per multiple stages (columns - SG0, SG1) for different type of Projects (rows). Also, we have to change the color of the Project Number on various conditions provided.
What I have Done:- i. I have used a CASE statement: "case when <MEASURE> = 1 then <DIMENSION_COL> else null end" (MEASURE column in RPD has set to "COUNT")
ii. I have made the Project Number column as hidden in the PIVOT View's COLUMN section
iii. I have created a column in database representing the n number of color settings required and kept that column as hidden in the PIVOT View's COLUMN section
My questions are as below:
a. What needs to be done to make the Project Numbers appear in a continuous way, i.e. there should not be any gaps between any two Project Numbers (current view is due to hidden Project Number column)
b. We have used conditional formatting for giving n number of colors in the report. When the formatting is different, the records are not displayed in the same column (04 Project Number with green and Pink is example). What needs to be done to make it appear in sync with the other project numbers in the same column? (current view is due to hidden COLOR column)
Please let me know if any other details are required or if I have missed any details which is required.
Thanks in advance.
