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

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.