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 ?

Do you believe you will get a discount on the license by double posting? Is BI Management Pack available for OBIEE 12c ? Double posting is the best way to: 1) not get any answer as the OP doesn't look serious and will not follow up 2) pollute forums with forever-open and not followed threads

Hi, For that kind of requirement you can maybe solve it with a bit weird workaround as long as things are exactly as posted. You will need a measure (in your example you don't have any measure) which count the number of users by activity (so a count / count distinct on the user). In the analysis you apply the filter on…

The miracles of Google .... https://docs.oracle.com/middleware/12212/lcm/RNINF/GUID-10F524EA-A008-4868-8AA5-3F19C7E787FE.htm#RNINF-GUID-7A3B718B-8205-44C5-9663-424A553070E0 From the doc: You can ignore this error because Node Manager does not use ADR. So yes, lot of people see that error (actually I guess I saw it in most…

After Christian pointed out a "detail" I skipped ("any other tuple of data") it's still not something OBI can do easily, and also something that SQL will require to store a lot of data (for every other possible tuple). So a different technology, as Christian said, would match better.

Hi Robert, A "nice" requirement Honestly the best "non-resource intensive way" crossing my mind is you do that by ETL while loading your data in the source. As the calculation must work on all the rows not selected by the filter it will be a nightmare both from a logical point of view to write in OBIEE and performance…

Well, it just works on the calculated item, of course you must have the same calculated item on the "detail" analysis. As I have a little doubt I put together a quick example: click on the calculated item of "master" automatically switch to the same calculated item in the detail.

After the super high quality of what I saw yesterday evening on TV .... yes, I HAD to mention it !