Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 214 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Unable to make column vertical and at center; Shifting column values to left
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.
Answers
-
For your first issue, Could you try below code in the custom CSS incolumn properties in pivot.
writing-mode: tb-rl; filter: flipv fliph
Second issue, will check and update you
0 -
Hello Asim,
Many Thanks for the suggestion, however, I have tried all the combinations of this. Initially, I had used this only, but the text was not coming to center, so added the remaining code.
0 -
transform: rotate(90deg);
or
transform: rotate(270deg); ( for opposite direction)
in the custom CSS
Use -webkit-transform:rotate(90deg); for other browsers other than IE
0 -
Hello Asim,
I am using Mozilla Firefox 55.0.3 for doing all these changes.
When I am using only the "transform: rotate(270deg); " plus the settings for CENTER, I am getting a distorted image as below:
I think it is making the text to middle, but in a distorted way.
0 -
did you try in IE?
0 -
Yes, same results...
Also, you suggested to use "
-webkit-transform:rotate(90deg); for other browsers other than IE"
So, I am building this report once and then users are running it on different browsers... How can I make it uniform for all the browsers at the time of building the report?
0 -
You need to keep both in code. it is working fine for me . Try to reduce the font size and check.
0 -
Looks like the requirement is to reproduce someone's excel sheet ... not the intent or design of OBIEE.
What business questions are to be answered? -- then use the functionality of the tool (OBIEE) to display the answer; chasing after 'requirements' that are to mimic another tool's (especially Excel) way of doing it typically are resource wasters.
0 -
@Asim, what both changes are you suggesting here? Can you please copy-paste the whole CSS code you are using as I can see you are using some "VERTICAL" setting as well in CSS? I am using the default font.
@Thomas: Your understanding is perfect... It's sort of excel transformation to OBIEE. I do agree with your point, but we can try to implement the same as realistic as possible to the client's original report as they have been using this for quite long now.
0 -
Dear,
It is not required. Where exactly you kept the code? kindly provide a print screen.
Try increasing the height of pane and reduce the font size.
0