Please do not double post

Please do not double post

Hi, Do you mind sharing the product name (and version) you are using? There are chances you are in the wrong forum, but can't really point you to a different place without more details of the product you are currently using.

Hi @Miguel Cardoso , The expression you posted, and the one Federico provided, will be evaluated only at the row level. It will return "Y" only if a person is self-managed. Are you trying to look if "Person Number" exists anywhere as a "Manager Person Number" in your whole dataset to identify by Y the persons being…

If when you analyze your data you do use only one or two of the 3 "OR" conditions in that join expression, what you can do is to create new aliases for that physical table and join them to the other table with the 3 different join expression (that would become just foreign key joins with columnA = columnB and … ). Then…

Just a random thought : is that a valid config for obis.properties? You are on Windows, and the export VARIABLE_NAME is a Linux command. You could maybe try with setbut no idea if it is "that simple"…

Is the page doing the embedding behind something? F5, proxy or anything else? Because if yes, the domain you add in OAS could maybe be that one, not the F5 or proxy etc. Or maybe all of them, as in theory the embedding is done by the browser that sees those sites at their “public” address (not fully sure with such a…

So, not only you have a F5, but you also have OHS in front of OAS? You have so many layers in between that the error you get probably doesn’t come from OAS at all. Each one of those layers can mess with your headers, remove them, override them. If you do embed the real OAS link, does it work? If yes, then you are fixed:…

ah! There is a “thing” in between… Did you check if your F5 isn’t messing with the headers set from OAS? Often that kind of product does override those headers for security reasons (providing a central management of CSP etc. in F5).

A MOS document was simply saying that this checkbox should do the job… I imagine you did restart your OAS after setting that? (Just to make sure settings are applied). Do you access your OAS directly or you go through a proxy or something like that? (The error message you posted gives a domain but no ports are visible, and…

I just gave it a try in the Model administration tool of OAS 2023 (7.0) and OAS 2024 (7.6) (your version of model admin tool is an OAC version in between these 2). Your original complex join works just fine. I just rewrote it in a different way but it's the same join condition (of course the expression is longer than this…

Did you add the domain of your page where your OAS is embedded as a safe domain in OAS enabling embedding? In DV > Console > Safe Domains , add your "subdomain" there and enable the embedding (do not enable it for "All domains", keep your OAS a bit safe). In old OBIEE there was a setting in instanceconfig.xml…

A complex join is just a “complex” name for a join condition that isn’t columnA = columnB (a straightforward primary - foreign key relation). The syntax to be used is still LSQL syntax and not your own datasource syntax, but the expression editor where you can write the complex join expression lists all the available…

@User_UQGO3 , Please start a new thread. Ask a new question here in the forum, describing your context, requirement, what you are trying to do and how, errors and also product name and version. This thread has been imported from a different forum, it did lose formatting, and your question is probably not really related to…

Hi, Wrong forum, this one is only for Oracle Analytics products. If you look for the general forum, covering also cloud, you maybe look for . For your issue, you should consider contact support because only support can have the privileges or procedures to handle your problem.

For example in OAS 2024 (7.6) it is done here:

Hi, What product (OAC, OAS, OAD, OBIEE?) and version? Because it's something that did change over time, therefore the answer depends on your version mostly.

I still didn't start analyzing the details of the metadata request (it's something I'm working on in the coming days to analyze a different thing in DV). At this point in time I don't know (still didn't look) if the metadata loaded is only the piece required by the visualization or is the full dataset metadata. In this…

That call is part of the usual embedding process, it generally comes before to executing the query to get the data and return it to the embedding javascript. Last time I had a look at embedding it was sending that POST query by sending the XML defining all the pieces of data present in the workbook and was returning a…