There are ways, there aren't simple ways. The catalog (the analysis) isn't aware of that info because that's covered by the RPD. You can export lineage information from your RPD, you can get the info of what subject areas or columns are used by the analysis, you can connect all the dots and get the whole info. It isn't…

Assign a sort order column and/or a descriptor ID column to your logical column. But it's just a warning, because it all depends how and where you are going to use your logical column, and based on that you will maybe never ever use the sort order column or the descriptor ID column. If you really want to get rid of that…

I'm downloading the files right now, no issues at all. While not knowing exactly how the Oracle website is built, the SampleApp 607 files are behind license agreement + login. From time to time the Oracle account struggle a bit and fail to login. Maybe try with a different browser or by deleting all temp files etc.

I just tested, it does work fine. Where are you entering it? (what is exactly that you call header) How are you writing the reference to the variable? A screenshot is worth more than hundreds of words...

Did you try just the normal syntax @{variable_name} ?

It's not relate to the generated queries or the source models (RPD). Sorry but if how can you say it isn't related to the RPD if you have the same behavior when creating an analysis? If you aren't using a DDR it definitely has something to do with the RPD and how queries are generated.

Hi, Maybe you want to start by providing a bit more context? What product and version? Did you look at the generated queries? How are they different when the column is alone vs when you have it with the additional column? Most of the time, you can see this kind of problems because of the source models (in your RPD) and how…

Don't you have in your RPD an object (user/role) defined that doesn't exist anymore in your OAS? The error seems to fail retrieving settings (grants etc.) of a user or role.

I probably got your question wrong... it will not give me every person that has the first name but not the last name and vice versa Did you try FIRST_NAME is not null AND LAST_NAME is not null ?

Can you test your settings by using them somewhere else (another program/tool)? Does the SMTP server have a public recognized SSL certificate? I didn't check right now on an OBIEE (I don't have a 12c running), but I believe it was also possible to set all the details (the CA etc.). SSL is always a lot of "fun", because it…

Not mandatory at all, it's just about disk space that it will take, and more in general having a clean folder structure on your disk. If you do it, you will maybe remember in 1-2 years why you have that kind of folder structure. But somebody else connecting to your server in 6 months knowing that OAS 6.4 is installed and…

Your install match what Christian called "wrong": your domain is right inside the Oracle home. If you do an in-place upgrade with this kind of folder structure, you will not be able to delete the 12.2.1.3 Oracle home, because it does contain the domain (and this one doesn't move during an in-place upgrade). You will never…

Hi, You just define the schemas first inside your physical database in the RPD, you then add tables inside the schemas. A schema isn't mandatory in the physical layer, but in that case all objects should be owned by the user you use to connect to the DB (and would require synonyms as you mentioned). If you define the…

Yes, but no. Manually you can, if you have some hours/days/weeks depending on the amount of things to do. But you can code all that. You can use WLST to code the creation of application roles, adding a "member" (app role, user, group) in an app role, removing "members" etc.

Do not confuse the definition of a user and a reference to a user. The BAR contains references to users and groups, because users and groups aren't created in EM, App roles are created in EM and therefore those are created based on what has been exported in the BAR. The OAS security has 2 sides: in WebLogic console you…

It has app roles and the members of app roles (so app roles being member of another app role, or accounts and groups being members of an app role). I didn't check lately the full format of how the user and groups are referenced, it's possible that because you change the source (AD now), they are referenced differently and…

A BAR doesn't contains the security done in WebLogic console and doesn't affect that at all.

https://community.oracle.com/tech/apps-infra/discussion/4495700/oas-5-9-ssl-setup-can-we-use-same-certs-for-dev-test-prod By the way, isn't it still time to move to OAS 6.4? ;-)

The OS/physical|virtual hardware doesn't, what could change my answer is if you did generate an open certificate covering all the possible subdomains (a wildcard certificate): in this case the same can be used for the 3 environments because the certificate will match the 3 different URL/domains (assuming they all share the…

You could, as long as the 3 environments have the same domain/url. So it depends, but probably you don't want it. If your 3 environments are behind 3 proxies installed locally (so that each can resolve the same domain/url to the local instance and not mix the 3), sure it can work. More realistically: I doubt you want that,…