@3371002 : keep in mind to check what settings do you really need and want and not copy/paste a bunch of things in your config file, mainly when there are pieces managed by Enterprise Manager (as comments in the file tell you).

The idea is the system is smart enough to pass all the required things by itself. Thinking at your temporary headcount and permanent headcount, if the tile has a filter for "type of employee" = permanent once and "time of employee" = temporary for the second one, if you keep the column you filtered in the criteria of the…

3365160 wrote:In obiee 12c go to /<ORACLE_HOME>/bi/bifoundation/web/msgdb/<language used>/productmessages.xmland change text as below Apparently you do not took the time to read the first line of that file there in Cote d'Ivoire ... DO NOT MODIFY THIS FILE. THIS FILE IS AUTOMATICALLY GENERATED AND IS REPLACED UPON UPGRADE…

If you places "<custommessage>" in the file the issue is that it's parsed as an XML tag, so you must try to avoid anything having special chars from a XML point of view (at least for debugging).

Hi, It really depend on what you exactly look for (so what kind of values you want to pass from the tile down to the detailed analysis) but there are ways with the normal action link behaviour. OBIEE pass all the values of the columns (so filters), and there are also ways to pass other things by using the OBIEE logic…

A bad news and a good news for you The bad one is that you can't do anything at the analysis level to get 0% instead of empty (because it's actually really empty). The "display as" doesn't give you any control on the format of the column. The good news is that if you calculate the % yourself with a formula (so a real…

Hi, what is your exact OBIEE version? Did you have a look in MOS? There is a bug and a patch related to catalog and permissions, not sure if it's the same one you are having or not ...

What's behind that column? What formula did you use or how did you display that column? (I assumed something earlier but you still didn't clearly said what's that thing ...)

The XML changed, in 11.1.1.9 if not wrong that "trick" doesn't work anymore. The 12c XML theoretically still accept some code for conditional formatting of totals rows (XML accepted and saved because matching the XSD), but there isn't the required code to understand and execute that part.

Are you sure the result is really 550'000 rows? Because the result of COUNT doesn't really mean that's the number of rows you get (there are aggregations happening). Do you really have 550'000 on screen when you expand your table to show all the rows? Also keep in mind OBIEE isn't a datapump tool, so default settings limit…

No data is not null ! So do you have data? Is that data null? Or there is just no data for these cells?

Hi, What's that column? Where does it come from? It looks like a duplicate inside the pivot and then selected a "display as %", is that right? In that case I would say that the empty cell is the right one and you cheated on the format on the columns next to the % to display 0 when there is no data. No data is different…

OBIEE 11g was certified on Windows 7 (for dev only), so it was possible to install it. The 11g to 12c upgrade doesn't need to have an accessible 11g from the 12c install : on the 12c you generate a JAR which you have to copy to your 11g, run commands on your 11g to pack the content into the jar, move back the result to…

For that kind of report ideally you must join with the list of objects in the catalog and match the path, so only existing agents show up. Or you have to cleanup the table by deleting the rows not matching anymore your needs... As the main purpose of these tables is to allow the scheduler to work and help in seeing if it…

No, It's normal (or better: it can be normal) that an agent you delete is still in these tables. The link between the agent in the catalog and entries in the S_NQ_JOB & co tables is really weak. There are situations in which the BI Server assign a new ID to an existing agent (for it's own reasons, saw that few times when…

To close the complex join thing: you didn't see the join in the BMM layer because it's complex and a drag and drop doesn't bring that join to the BMM layer. Foreign keys joins comes when you drag and drop the whole physical model. A complex one doesn't work an an identified foreign key column as it's complex, so you just…

Srini VEERAVALLI wrote:... try to create physical join in BMM layer and see how that works. Sorry but doesn't exist anymore in OBIEE 12c, that was something doable (when desperate ) in 11g (or 10g, can't remember).

Hi Helena, The content of these tables isn't something you must touch, OBIEE manage it by itself. Sometimes it deletes everything, sometimes as it create duplicate entries it just delete the last one (and it's fine as the previous one has a different ID which doesn't match an object of your catalog anymore). If you go into…

Sorry to ask but ... all your OPMN components are up and running? Not that your OBIS is down because of that "new" rpd?

Hi, It's ages I do not look at MAD anymore but I'm 95% sure you can write plugins for it. Your own plugins using JS etc. to add extra visualisations, so you can also add any kind of ticker you will need. But it's custom code done by yourself (I do not remember a plugin doing that).