I would say the subject areas structure is, at some point, the less important. The structure of the business model is way more important as the rule is simple: 1 subject area = 1 business model, 1 business model = N subject areas. So if your business models are structured nicely you can always have huge subject areas or…

Your column is badly defined in the RPD. If the year (I assume it's a year column) doesn't have NULLs, don't define the relative physical column as nullable. The '.00' is maybe because it is defined as a different type than integer?

OBIEE has never been about writing queries. You model things and the tool write queries. The front end is kind of not so important. The RPD is where everything happen. And you need to master SQL to know what kind of queries and models can generate the right queries answering the business needs your model must cover.…

3200605 wrote:I know that anything you do in the front end , a query is generated .... I would disagree on that being a bit pedant. Sure it generate a logical query, but doesn’t mean there is a query sent somewhere else (which is maybe what you mean with your comment). A subquery is a query which is ”sub”, underneath,…

Must admit that Christian has a point: they asked what to do after creating and you answer how to create. By the way: isn’t it on the left? At least every single weblogic I saw it was on “the other right“ Depending on the context (what has been asked before and the role you had the interview for) you could have said that…

And why don't you post your answers as well? So users of the forum can tell you if you answered well or complete what is required ... And is 2) really related to weblogic? You maybe need to provide some context ...

You can't really extend usage tracking itself to add extra pieces of information. You can get the info you look for from the presentation service logs which are more like a webserver kind of logs and there you must have the IP address. You can read about it logging in Presentation Service at…

Which is the last option I posted: it will depend on the underneath model, on which we have no idea.

Sorry but, did you read the link which has been posted in the other thread and this one on how to deploy a folder in Weblogic? If you did you can't possibly try to enter https://.../analytics/bi/domain/fmw/user_projects/domains/bi in your browser and hope to see something. Weblogic is an application server, it isn't just…

You create formula giving the total amount on the left, you subtract a formula giving you the total amount on the right and you have your number in a cell. You can then use a narrative view to display it the way you prefer. Grand total in pivot views are automatically calculated by OBIEE aggregating at the required level…

So you are now back at your previous thread. You asked how to display a picture hosted somewhere else (google or whatever) inside an OBIEE page, you got an answer. You asked how to store and display images hosted on your OAC server, you got an answer. You got all the answers to do just what you want to do, you have…

It's a bit more weird than that S_NQ_JOB is the one having JOB_ID as PK, while in S_NQ_JOB_PARAM it's a FK. For 1 given agent you are supposed to have a single JOB_ID, both in S_NQ_JOB and S_NQ_JOB_PARAM. If you really want to restart "clean" you can truncate both tables (and maybe the ERROR one too as errors without the…

Nayas wrote:Right now, the s_nq_job_param has duplicate records for the same Agent. So all the rows are in double for the same exact JOB_ID ? Or you have 2 different JOB_ID which reference the same agent?

You could maybe try with a CASE WHEN to filter the "use_date" for the required "event" value, and than hoping you at least have the right dimensions to aggregate so that the value can be available next to any "event" value. There is still a little chance it could work, but really depends a lot on the model you have in…

In OBIEE there 2 main kind of values: attributes (dimensional attributes) and measures. OBIEE requires a star schema, so the basic concept of a start schema is a fact table with dimensions linked to it (I'm skipping degenerated dimensions and other kind of "exotic" models on purpose to keep it simple). All the columns of…

I supposed your "Use_date" was a measure as you use it as cell value in your pivot ... Why isn't it a measure if you make analysis using it as a measure?

Feel free to come back even if not needed (meaning it works) just to close the thread

Hi, you can use FILTER(... USING ...), it's supposed to get you what you look for. https://gerardnico.com/dat/obiee/obips/filter_function

Need to correct myself: OAC isn't using an external proxy/load balancer anymore. Now there is a proxy running on your OAC instance itself. Based on the proxy config I saw, if you deploy something on your OAC weblogic ("analyticsRes" for example) it will be part of the forward as it's really a high level forward of anything…

Adolfo Gorjon wrote:validated, if I have access to the file instanceconfig.xml It isn't an IF : you have access to that file, that's how OAC works. The thing with "analyticsRes" (which is the concept covered in https://gianniceresa.com/2016/12/deploy-custom-folder-obiee-12c-analyticsres/ ) is to deploy a folder on the…