A detail first: "reply asap" in a community forum where users are investing their own personal time and aren't paid to post any reply is considered unpolite, try to avoid it in the future (or hire a consultant and he will be paid to reply "asap"). Did you try with a CASE WHEN ? It's the IF-ELSE in an OBIEE analysis.

BIP is a different product, it's totally different as it works with data models and it's a totally different thing. I suspect you will need to do manual parsing of things to get some info out BIP reports.

The security logic is the same, but at the moment you should focus on tracking things in your OAS without caring much about 12c. A user to be able to login should first have a valid username and password that will be authenticated, after it should have the required authorizations and those come from roles. Start debugging…

Did you configure the security? Just defining a LDAP is only part of the configuration, you cover authentication, but you still need to deal with authorization. Do your users have roles? Are the roles correct? Do they inherit privileges from the default roles? Did you create fully new roles?

At report level or server-wide in the Administration page > Runtime configuration > Properties.

You can't? You can use whatever variable you want in the LSQL of a prompt, what make you say that you can't use the variables? Are you saying that because you don't see it working? Did your page reload after setting the first 2 prompts? Because if you don't submit prompts, the variables still don't exist and therefore your…

The header isn't a formula field, it's a text field. Variables are matched and replaced. Your 'variable' || ' ' || etc. should be written as text with the variables inside, don't try to concatenate things or anything like that. Because it's only a variable replacement, it will match the variable value, the default value…

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…