You are storing your image in the OBIEE catalog, which is probably the worse place for that. Files stored in the catalog can't be accessed as a normal image store on a webserver, you need to access them using the OBIEE way to retrieve an object from the catalog. All the details here:…

Picture? Which picture? Do you see tables in any other schema? Maybe you just don't have the permissions, with the user you connect to the DB, to see tables in that schema ...

All depends on how the report is sent and the amount of logs the SMTP has (like attachment names, subject etc.), a lot less friendly but just another option on top of others. The easiest is obviously what Joel said: it's generated by OBIEE, so of course it has the best links with OBIEE content.

On top of what Joel said, you can take the problem from the other side (outside OBIEE): your email are delivered via a mail server (SMTP), so look at the logs of your SMTP and you must find out exactly which email has been sent and to whom.

You better open a new thread explaining your case as the OP gave up on this (so didn't answer to any question etc.).

The issue you see is expected if you think at the agent from a security point of view: your agent is running as a specified user (which is referenced inside the agent itself), so OBIEE "login" as that user and execute the agent (run the analysis) and send the result by email to a list of random addresses you added. If you…

That's why the CSS was an example showing in which way it could be done (but I didn't spent 1h of tests on something I didn't need as 12.2.1.3 just works fine).

Did you read the blog post linked above on how to embed D3 in OBIEE using a narrative? There you see how to do it ... (https://www.rittmanmead.com/blog/content/images/2016/05/06663d3_narrative1.png ) @1, @2, @3 contains a single value each time, they are relative to a single row, so you need to use a piece of code which,…

It can also not exist and it's up to you to create it, but there must be for sure a JS library doing it ... (you then embed it the same way as D3) Look at this for example: https://plot.ly/javascript/3d-axes/

Hi, If you look into SampleApp 607 you find few scripts which extract data allowing you do that that kind of analysis... The idea is to search in the catalog (a XML search) the paths of the objects (your filter or your dashboard page), and there you get the list as OBIEE always use full absolute paths to link things. For…

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…