You need to use an absolute path as d3 isn't deployed next to the analysis. If your "analyticsRes" folder is deployed as /analyticsRes then you need to use /analyticsRes/d3/d3.js (assuming you created a d3 folder and put the file inside). But yes, with that kind of syntax you load d3, then you have to use it and that's a…

As Joel said "analyticsRes" is the clean simple way of doing it. An alternative is to use the D3 which is already included in your OBIEE. VA/DV uses D3 and has it (it's part of the RequireJs config), so you can also load it from there. It's probably a older version (v3, not v4) and the path is a bit weird (look at it with…

If in OBIEE everything is fine (looking at the logs of the agent) then you will have to go and look in your SMTP server logs to see why the email wasn't sent out to the final user.

As the OP doesn't really formulate in question in a way to give him a unique answer, all the above are valid answers. It all depends on the granularity of the OP data and what model he adopted (even monthly figures can be attached to a single day which can be the first of the month, the last etc.). Chris Arnold pointed the…

Hi, Of course you can. Just create the join as always and then open the "Expression Builder" and there you write / create your complex join condition.

That's what I wasn't sure anymore by not having a BAR around: BICS bar are "protected", so can't be opened as easily as BARs from 12c / OAC.

A BAR file in general is just a "zip", so you can open it with any tool able to open a ZIP. There inside you must find the RPD somewhere (there must be few folders for RPD, catalog and security). The next challenge will the password for the RPD : no idea where you can find that one ... (can't remember if BICS ask you to…

You want 3 green thing which just doesn't care at all of your values? Did you try using a logarithmic scale if you want to reduce the gap when having big numbers?

DongxiYU wrote:Yes, runcat.cmd can used in CMD. But it does not has an option to open a specified catalog.With UI, I can open catalog such as "HOST:PORT/analytics/saw.dll". Is there any other offical doc? You didn't really run the command, did you?…

Hi, Quite vague question ... The key element is to keep in mind what layers means in OBIEE. Physical layer represent the reality of your physical sources. In your case there you will have your 7 tables with all the required links. Do not think fact or dimension here, just link things based on what your data require (so…

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…