That workaround editing the XML stopped working in 11.1.1.9 already, and since then ... nothing else is available, the XML is just different and the newly accepted formats aren't rendered (so the XML could still take code defining formatting but it is just ignored).

Hi Charles, So I assume all the objects works fine and your issues is "just" that between the 2 environments the paths aren't the same. If the objects doesn't work (you can't open them etc.) you have other issues (probably related to security). To make it more clear why you have this behaviour when deploying something in a…

It's Oracle SQL, you are bypassing OBIEE by using EVALUATE_AGGR, so you need to solve that from a SQL point of view.

You better do not mix versions, you have a 12.2.1.2.0 server then install the 12.2.1.2.0 client as well. You can have as many clients installed in the same time on your workstation, so you have the right version for the right server.

Yes, the removed the certification a weeks ago (this is the doc: https://support.oracle.com/epmos/faces/DocContentDisplay?id=2323361.1 ) If you use 3rd party drivers you maybe have more chances by using an ODBC connection, and OBIEE will not really be aware of what your driver is, it will just speak ODBC with the driver…

In a default OBIEE install you can't do it as security is managed by the Fusion Middleware, going back to application policies.

Publisher isn't managed as a privilege in the OBIEE admin front-end page but by policies. So adjust the policies for the application roles you need to. (forget about users and groups: do things only at the application role level) To give you some hints : https://www.justanalytics.com/blog/managing-bi-publisher-access 

Do not stop at the basic usage of that command (and Joel is 100% right) Of course no "double click" execution, you need to run the command by command line to not get it opening the GUI and start having fun in your script (runcat.cmd/.sh is quite powerful ! )

OMAR_BI wrote:... I have downloaded the BI client version 12c (12.2.1.3.0), Could someone please direct me to the page or installation instructions (step by step). The "BI client" is only the Admintool, Catalog Manager and Job Manager and are client tools you install on your Windows laptop/workstation. It isn't the OBIEE…

In addition to Martin's point (which is definitely a +10000 : keep your RPD clean), if you are asking more from a "will this be an issue" point of view the answer is not: physical joins aren't used if you don't have something in the business model using the physical objects and requiring to go through that join to connect…

Isn't that the same exact thing as How to connect to 12C SSL DB using SQL Developer? ? Or this time it is an OBIEE question?

Usage Tracking gives you executed things against your OBI Server, not all the activities. For example you will not know when somebody download something or delete an object. For that you will need to look into the OBI Presentation Service logging. To make it simpler have a look at this:…

Bad news for you: that login page is a bit "funnier" to customize ... Have a look at https://gianniceresa.com/2017/10/odc-appreciation-day-customize-style-of-lightweight-login-and-vadv/ to better understand why. This thing is an independent deployment in weblogic (as you can see from the URL) and it hasn't an official…

"general" isn't really explicit ... "general" as the general login page OBIEE had for the last 5+ years? or "general" as the one you got out of the box when installed the tool? Post the link of the page or a screenshot to be fixed on which one you want to customize as one is easy, the other one is shitty ...

Doesn't really work like that ... The functions you see available in the edit formula window are all functions the BI Server knows how to translate into code for the various DB it can talk to (so SQL for Oracle, SQL Server, DB2 etc. but also into MDX for Essbase cubes etc.). So you can't write functions like that, because…

The atr files will just not accept to go from .9 to .7. Can't remember how the XML changed between .7 and .9, but you maybe have more luck by copying the XML code of your objects and cross your fingers (there are chances some pieces will disappear or complain about unknown tags, you will have to fix that by hand). Catalog…

It's a good thing you are new to javascript as you don't need javascript. Java and Javascript must not be confused as they aren't related at all. As said the official doc has EJB sample code in it and as Christian said MOS also has documents with it. Look for these things. (Google also has some blog posts about it)

It mainly depend what is the login page you are using in your 12.2.1.3 (there are 2 login page: the normal one and the lightweight SSO which is enabled by default).

Windows or Linux it's the same way. The only difference is that Windows also support VB scripts, while on a Linux install you need to use EJB. So just look for that (I guess even the Oracle doc had a EJB sample inside on how to save a report to disk).

Well ... the process looks right on the paper, but if Weblogic complains something must be wrong. Sure it can be Weblogic itself (I kind of try to stay away from Windows installs as I like to avoid issues). For sure bicustom.ear with 12.2.1.3 works as I deployed one 2 days ago and logo and colors appears as expected based…