Hi, a MOD is a moderator of the forum. They already did the job, your question (thread) is now in the OBIA space and hopefully the users of the product will stop by ans give some hints. OBIEE is a product, ODI is another product. OBIA is a pack of various product with pre-built content and connections between the pieces.…

So ideally it's a question for or (if you have MOS access). Let's see if a mod can move the question there. OBIA has a document/analysis explaining the models etc. Not sure it really goes back to the ERP itself, but being pre-packaged content (including the ETL) it's possible.

Do you have a "packaged" product? Something like OBIA for example? OBIEE comes empty, ODI comes empty. All these tools do not come with any content. If you don't have a packaged product like OBIA, you must ask all the documentation to your own company as somebody there had to develop everything. Hopefully they developed…

OBIEE is the less dependant piece of OBIA, even OBIA 9.7.6 can be upgraded to use OBIEE 12c without touching anything else. That's the easier and safer move you have: move to a newer OBIEE fixing your Flash issues. Sure there is a setting telling OBIEE (including .7) to display pictures instead of Flash for charts, but you…

user3897389 wrote:ORA-01034: ORACLE not availableORA-27102: out of memory You would need to ask in the database forum as those errors aren't OBIEE errors but database errors. There is a problem with your database, therefore OBIEE can't do the job, but the errors are database errors, so look there.

The certification matrix is the reference document, support can't "override" (reducing) the certification matrix without correcting the matrix available. Ideally support can only extend the certification matrix by affirming that something newer not listed is also officially supported (like Informatica 10.2 while the matrix…

Great it worked. Luckily you have this double security allowing you to really pick who can query which source as otherwise it would be too open. So you can close the thread

If you search for "direct database requests" in the help of the Admintool you get it: Allowing or Disallowing Direct Database RequestsYou can allow or disallow the ability to execute direct database requests for a particular application role.For the selected role, this privilege overrides the property Allow direct database…

Did you configure permissions in the Admintool? The error message tell you exactly that ...

3808468 wrote:OBIA is on 11 g server, how obiee 12c( server2) Prebuild RPD and Reports and Dashboards can communicate with OBIA 7964(server1) It doesn't, because of what Christian said. You need to forget OBIA 7964 as a product, because it isn't a product. OBIA 7964 is not a tool. OBIA 7964 is "simply" a bundle package: it…

I already wrote them above Let's reformulate in a different way: server1 = OBIEE 11g + DAC + Informatica ?

I have a feeling of "déjà vu" As you plan to use OBIEE 12c as front-end, your OBIEE 11g is required but will not be much used, therefore not a problem to have it on the same server as DAC & Informatica as OBIEE 11g there will be like "transparent", not adding any relevant load on the system.

Hi, All your answers can be found in the relative certification matrix: https://www.oracle.com/technetwork/middleware/ias/downloads/fusion-certification-100350.html PS: you maybe want to have a look at as you never closed a single thread so far ...

Informatica is another company, you need to ask them. I would double check the licensing of your OBIA, because not sure you can split the product apart and use pieces with other reporting tools (and for sure you still need full OBIA license for it anyway).

Honestly when it's about licensing it's a nightmare: having an OBIA license doesn't mean you also have a support contract for it etc. The best way to figure out would be to ask the person in your company in charge of contracts and licensing of the Oracle tools: hopefully there is somebody having that role and he is aware…

Good point: no idea if it isn't mentioned in the OBIEE 11.1.1.9 certification matrix because of "timing" (both 11.1.1.9 and SQL Server 2014 have been released almost at the same time, therefore no time to test and certify it). This is maybe something where people having OBIA itself could have a better answer PS: I asked…

It's true that if you want OBIEE 12c with OBIA (any OBIA version) you need a separate install of OBIEE (so it isn't about upgrading the one out of the box). That's what your machine 2) is for. But doesn't mean you need to split Informatica & DAC away from OBIEE 11g. And because that OBIEE 11g isn't used I wouldn't plan way…

To add extra wording to Christian reply: OBIA is Informatica + DAC + OBIEE 11g + the warehouse You have your warehouse in your MS SQL Server, good. So the "rest" of OBIA (Informatica + DAC + OBIEE 11g) can be all together in the same place, mainly because that OBIEE 11g will not receive requests as your users will be using…

The answer is here: https://www.oracle.com/technetwork/middleware/ias/downloads/fusion-certification-100350.html Look at the certification matrix for both BI Apps 7.9.6.4 and OBIEE 12c 12.2.1.4 (as they are separate products). If both are certified for Windows Server 2016 you will be good, if one of the 2 isn't certified I…

3808468 wrote:2) Can I directly connect with the DB using OBIEE 12c ( I have RD, Catalog, users and groups) without obia 7964 and obiee 11g? A side note on this: technical solutions can be different than licensing. You would still need the OBIA license to use it's content. Just adding this as somebody in the past asked…