Christian Berg wrote: /system should only ever be moved in offline mode I guess it's a ... Yes, you should try it offline

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…

As you have a really really really (once again: really) old version, did you check the release notes of the following bundle patches to see if one mentioned a fix for a possible bug/weird behavior of the descriptor ID? Your current bundle patch is almost 4 years old, you maybe want to consider to move to the last one while…

You can easily script things, doing queries on the usage tracking table and loading the runcat results with a list of all the objects etc. I also have the impression the create and modified date you get from runcat are ... a bit random (I had some weird results in the past on those fields).

Hi, For that info you better setup (if not already done) and use usage tracking. In the past I found the created and last modifier info to be a bit weird, while usage tracking is more reliable.

In addition to Joel comment, have a look at This will get you the best answers ...

The real answer has been posted multiple times already. Now an OBIEE analysis is a webpage, so of course you can have some custom JS/CSS code doing what you look for, but it will be a visual hack working only on screen. If exported will not be there, if printed will probably break. So is it worth the effort? Not really !…

Is your OBIEE working? Or is it down? And you maybe want to review and post some extra pieces other than few lines of a log.

You have been slow on this one ... doing the screenshot took you longer than expected (that's why I didn't go into many details as I knew you were doing it)

The system wide defaults are stored in the catalog, but in the /system path, so you would need to move those settings as well and not just the subpart of /shared you look for.

3690885 wrote:Ma demande d'aide concerne la bonne configuration et l'exploitation de la solution OBIEE 12C. J'ai besoin d'un résumé du document technique sur l'administration de l'OBIEE 12C en français si vous avez. Hi, I'm not going to translate that for the community as others suggested they would do it (sorry Christian,…

Did you try Blog : How to Fix ID Errors In Reports After Upgrading From OBIEE 11g to 12c ? Not the same versions but depending on how the upgrade went you maybe have some permissions issues ...

Martin van Donselaar wrote:Yes that is correct, I was thinking too complicated :/ Or thinking right when other columns get in the analysis (or the 2 mentioned aren't there). Never ever imagine the OP will do just what he asked for on the thread

"zero values" = no value at all, nothing (not a 0, not a NULL, not a "" ... just nothing) OBIEE will never generate data which doesn't exist, so you better fix that during ETL to add at least an empty/NULL/zero row at that point. Or you need to model things to cover this case with the right logic (or use EVALUATE to send a…

Robeen wrote:....as a database administrator what would be my role? Your role? Sit down and enjoy your coffee As a DBA from a BI point of view you don't really have an active role as long as your BI developers know their job. In a more realistic situation you will probably have to help diagnose slow queries and find out if…

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…

Dimitris Karydis wrote:Yes that's exactly what I am doing. I knew that was the reason (ok, the screenshot was also quite obvious ...) The issue with pivot view is that there are tons of interactions you can do when visualizing it (either the analysis itself or in a page), things like moving columns, sorting, add or remove…

Hi, I didn't read the full thread but ... aren't you try to cheat and complaining your cheat doesn't work? Do you actually have something else (at least another column) visible there where you have the grey in the "Rows" part of the pivot? Because from your screenshot it looks like you use a pivot but want it to act as a…

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>

Hi, Did you try searching the forum, the doc and even just Google? It's one of the most asked questions and the answer is always the same ...