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…

Can definitely confirm you can freely configure CSP in your OAC instance to allow to embed images from an external host. The default on the config can be found here: https://docs.oracle.com/middleware/1221/biee/BIESG/answersconfigset.htm#BIESG9326 And by SSH you have access to instanceconfig.xml in…

The images hosted on outside your OAC (google etc.) I would say they aren't visibile because of CSP, it's something which can be configured in OBIEE and therefore you can also configure in OAC I would say. The only thing to keep in mind is how upgrade will be performed: will your customized instanceconfig.xml be preserved…

So I hope you don't mind if we keep it here instead of into comments of a blog post. Will also be easier for others to contribute

You are counting the number of occurrences of ACT_CAND not being null, that's your measure. And because of duplicate you could it in a distinct way based on J_GROUP, PI_COMP_DT and CAN_NUM. Now look around your dataset and check if there isn't something which already had the right granularity, it's a COUNT, it could work…

What is your measure? What makes it unique? As you are looking for a COUNT it's often possible to use alternative columns which have the required granularity. If not exists it's up to you to create it: you can concatenate together multiple columns etc. You need to open up your mind thinking at alternatives giving the same…

If you model things as fact and dimension, all the attribute in the dimension will have an implicit distinct and be unique. For the fact you simply need to adjust the fact column to correspond to the combination of columns you need to do a COUNT(DISTINCT ) on. You set "count distinct" as aggregation and done. The column…

Sorry but how can you get a count of something by running a SELECT DISTINCT ? To count something you are supposed to have a COUNT() and GROUP BY or use the relative analytical function. Ignoring the incoherence of the "SQL" not sure what you are looking for: you want to know how to get OBIEE to make a SELECT on your view?…