Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 214 Oracle Analytics News
- 43 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
Back Ground Color for the Table Row Cell - Conditional Format - Direct Database Request (DDR)
We have created an analysis using Direct Database Request (DDR) in OBIEE 12c
In the DDR we are using Table ouput to show the Total and Grand Totals of the Cost Information.
I can able to get Font color bold using below Tag in the DDR Query ( Properties of the Column is changed as "HTML") column.
<B> <FONT COLOR= "red"> red </FONT></B>
But unable to get Background Color for the particulr Table Cell column. I am using the below formatted html information.
<B> <body bgcolor= "green"> green </body></B>
Any suggestions/Solutions to get background color
Answers
-
Hi,
What you look for is HTML (so not OBIEE or any Oracle tool), and you were quite optimistic with <b><body>.... (<body> is supposed to be unique in a webpage as it represent ... the body of the page).
You need just a line of CSS for that, something like:
<div style="background-color: #00ff00">green</div>
0 -
Apart from Gianni's input I hope that you are aware that DDRs are exception cases and not how the tool is supposed to be utilized.
Oracle always said and we in here have said it 500000 times: Use DDRs and you can forget about much of the out-of-the-box functionality
0 -
Dear User,
You can use something like this:
SELECT '<font color=WHITE>' || 'CHECK THIS IS DEFAULT' || '</font>' AS DUMMY FROM DUAL;
And modify Column properties -->
OUTPUT:
Hope this helps...
0 -
But when you export into PDF output, background color is not coming in the output.
0 -
Hi Ceresa,
On the table cell how to apply this div style ? currently i can able to get for the text background color,
not for the complete cell
0 -
The answer is in what Christian wrote: a DDR doesn't give you almost any of the feature the tool as.
It's all about cheating ...
By CSS you can force things to try to match the cell size as much as possible, but it's all about cheating and a shitty one as the rest of the HTML is generated by the tool. So do not expect a perfect or nice result. You are bypassing all what make OBIEE a great tool. Live with it !
If you model things correctly you don't have that issue, it would be a functionality there out of the box and working very well.
(If you add your query in the RPD as an opaque view you still don't need to model anything but at least you will use the tool for what it is: an analytical and reporting solution using the RPD as "brain".)
0 -
Gianni Ceresa wrote:The answer is in what Christian wrote: a DDR doesn't give you almost any of the feature the tool as.[...]You are bypassing all what make OBIEE a great tool. Live with it ![...]
Even if this thread goes on for yet another week, the answer will never change @user13683029
0 -
Hi Christian,
It is applying for all the column values in that table cell. We need for particular row in the table to highlight.
Can you let me know possibility
0 -
Looks like you keep ignoring the answer: if you do a DDR you are bypassing most of what the tool does, so do not expect to have all the feature after.
Conditional formatting, styling etc. is some of those feature. As said above you are "cheating" by adding some HTML in your values to render colors etc.
You can't expect the PDF export of the tool to translate that into colors, the PDF export is coded to understand and translate into PDF the OBIEE styling and conditional formatting, all the things you lose when doing DDR.
As already posted you can put things into opaque view and still load them in the RPD and have a fake model for those object so you most of the feature of the front end working again, so just stay with your DDR and don't expect things to work as OBIEE, because DDR is bypassing OBIEE and you are just returning a result of a query in a webpage and not much more.
0 -
As everyone has said, using DDR bypasses the OOTB OBIEE functionality. It has been mentioned how to get conditional formatting working in a DDR but that will have it's limitations as you've found out with the pdf exporting.
You can either manage it as it is or add the data source to your repository and do it the right way and everything will work as you'd expect it to.
0
