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).

Hi, Isn't it like OBIEE mainly a licensing thing? And I guess I remember you can't do everything you want on the weblogic coming from OBIEE outside of OBIEE things ....

Hi, OMAR_BI wrote:I am having problem .... Like what for example? What's the problem? But your model seems to have issues as you are aggregating attributes by fact columns ....

Hi, It depends on what you try to achieve ... First the joins in BMM are ideally done by hand, when you get them by drag&drop it means you are using the exact same keys as the physical layer, but that's not how things are supposed to be, the idea of the BMM layer is to forget the physical structure of things and think from…

Hi, What's your starting point? Do you have the data already in OBIEE and the "table data" you posted is how your analysis currently look like? You just have a random Excel file with these columns and want to create a chart? What tool are you exactly using / want to use? (OBIEE Answers, DV/VA etc.) The better you ask your…

Hi, XMLQUERY is a database function, OBIEE isn't aware of that function and will never do anything with it. So you can use a direct database request (I guess it already existed in 10g, but as you use a 10+ years old tool ... difficult to be sure) or EVALUATE (assuming this one also existed at that time). PS: not sure of…

If you ask things in the right way you get the right answers. And what I posted earlier works for SQL Server as well as Christian screenshot show. OBIEE support many kind of sources, SQL Server is one of them like documentation, certification matrix and many other official resources say.

Hi, Open the BI Administration tool, open the RPD: option A: right click in the physical layer > new database, right click > new connection pool option B: File > Import metadata, follow the steps Your SQL Server connection is there.

Hi, I would suggest you go on a linux VM as it's free (Windows Server you can get it for trial I guess but at some point it will expire). So for linux I generally take Oracle Enterprise linux for the simple reason that Oracle also use this one (as they release it). If you install it (latest version works fine, so 7.3) with…

Did you start by searching the forum? It must be the 5th question about OBIEE 12c on Windows 10 in the last 2-3 weeks. And the main answer is that Windows 10 isn't, like any other Windows desktop OS, a supported version for OBIEE 12c. OBIEE is a server tool not meant to run on a desktop OS on a laptop. A VM running a…

Hi, any kind of image your browser will understand will work. Keep in mind it's a webpage, so no special rules there. Where does these images come from ? If from another server / domain you have CSP (content security policy) blocking things and you simply need to configure it right.

@user2461087 : Do you mind following up on your thread? As this is a community forum the idea is to give & take (not just take, for that you pay a consultant). Or close it if you don't care (the answer is there inside...). Or we can follow up directly with the bank

Hi, You got many pieces of info above already but I guess it's good to go back on how things works first ... A database object in the physical layer (in your case "ORCL") can have one or many connection pools. The standard case is that all the data always come from the first connection pool. So why does OBIEE allow you to…

double post Is BI Management Pack available for OBIEE 12c ?