You just have to take it step by step and combine all the pieces like when playing with Lego... TRIM(BOTH ' ' FROM SUBSTRING('De Army, Miss Lucinda Diana' FROM LOCATE(' ', 'De Army, Miss Lucinda Diana', LOCATE(', ', 'De Army, Miss Lucinda Diana')+2) FOR LOCATE(' ', 'De Army, Miss Lucinda Diana', LOCATE(' ', 'De Army, Miss…

You did install OBIEE 12c on a Windows 10 OS? Drop your vm, create a new one with a supported OS and reinstall. OBIEE 12c is NOT certified to run on Windows desktop versions. The forum is full of threads of people who "successfully" installed the tool but it just doesn't work (the lucky one saw it once till a reboot, the…

As its production env, logging disabled. Sorry but what is this supposed to mean? What’s the theory of disabling logging in prod? Please don’t tell me it’s because you believe the myth that disabling logging improve performance. Exactly because it’s a prod environment you need logging, because guess what? How are you…

Are they really reports? Or just analysis? You do have logs, don't you? You can see what the analysis does when you open the page, the logs tells you everything. A forum can't guess much while the logs tells you exactly what is going on, and as a direct consequence you can see what actions need to taken to change the…

Look at the function LOCATEN , it allows to use a 3rd parameter being the character where to start looking for your search thing. You will need to combine LOCATE and LOCATEN a few times to find, for example, the location of the space character before the name and then the space after it or just the end of the whole string,…

Do we agree you aren't really looking for any reply? Because your thread is empty....

This is not true. we can upgrade from 12.2.1.3 as well. Of course, you can even migrate from 11g, but the documentation only gives the process from 12.2.1.4 and for everything else it's a generic "If you want to export metadata from other 12c releases, use the corresponding command to create the export bundle.". How about…

What exact version of OBIEE is that? Because there is none certified for Windows 10. 11g is the last one that, by mistake, was certified on a desktop OS (up to Windows 8.1), 12c has never been certified for a Windows desktop version.

Ok, the real error is behind the "[+] Error Details" link, if you expand it, you get the real error. Your expression isn't a valid expression because your CASE WHEN is not closed. The syntax of a CASE WHEN is: CASE WHEN <condition> THEN <value/expression>[ WHEN <condition> THEN <value/expression> ]+[ ELSE…

An error ... like what? What was your formula and what was your error?

Look at the function TIMESTAMPADD and you will be able to get what you are after.

Is your personal machine running a Windows desktop version? (7, 8, 10, 11) If yes, stop there, delete everything you installed and use a VM with a supported and certified OS. Here in the forum you will find 1-2 posts a week about installing an enterprise application on a Windows desktop version (that are NOT certified) and…

It's challenging to guess what the situation is... My first random guess: isn't it just a case that your data contains line breaks and the HTML rendering doesn't show them because by default line breaks have no impact? If that's the case, you can change a CSS rule to have your line breaks visible on screen:…

Set a sort order column on that logical column pointing to a column having a format that can be sorted, something like YYYY-MM.

https://community.oracle.com/tech/apps-infra/discussion/comment/16853661#Comment_16853661 Something... Again, as I posted above: You could maybe start with a minimum of context, things like a product name and version (it is by far not an implicit thing) etc. Just a random piece of an error message isn't really going to get…

Hi, You were maybe a bit too focused on trying to find a fix for your issue when posting. You could maybe start with a minimum of context, things like a product name and version (it is by far not an implicit thing) etc. Just a random piece of an error message isn't really going to get you much other than random guesses.

A random quick check gave me this note: Kerberos modules for Apache on Windows are only free available for Apache 2.2. With Apache 2.4 on Windows (x86 or x64) you either have to purchase a pre-compiled module or need to compile the latest module version on your own. Sounds like it is possible for Apache 2.4, just depends…

Installing a product that isn't supported and is more than 7 years old? You are at least hopefully using a certified OS, because otherwise it's pointless to even keep trying. Your should find detailed logs, probably also in the component's log directly, giving you reasons for something not starting. The message posted just…

As roles are retrieved after the validation of username & password, during a login the user should have the new role. Can your User #1 do the things that only role C allows? Maybe you have a browser cache of the "my account" screen and it is only a visual issue. Mainly if you have everything by default I don't expect any…

The thing is that the Model Administration Tool only asks you for hostname and port number, because OAC has something special in place. I didn't look into the packets exchanged between the Model Administration Tool and OAC, but my guess is that there is a proxy in between and I can't even say if it is an ODBC connection at…