@User_PHX1F , Welcome to the forum. As this is a 3+ years old thread abandoned by the owner, how about you create a new one asking your question and providing your context (a product name and exact version is always helpful). You will get more chanced to have helpful replies quickly, without having "same exact issue" that…

so All I have is numeric values as string and casting should solve the problem . Not really, and that's what Federico was saying: you can cast all you want, but if you don't tell OBIEE/OAS that the column is a measure, the tool isn't going to aggregate anything. Did you tell the tool that column is a measure and should be…

Isn't this just the same as https://community.oracle.com/tech/apps-infra/discussion/4507121/siebal-dac-v7-8-2-is-compatible-with-informatica-version-10-5#latest ? For your compatibility question, it's generally quite simple: products come with a certification matrix listing what is officially certified or not with it. If,…

I will not say I agree or disagree, but that's the price to pay to have a cloud product running on a black box (no access to the system or any config file) ported to on-premises. Do I like it? Nope Can I live with it? Not really a choice...

I was expecting that kind of reply, but in all fairness you only gave examples with a fixed format in the first place... You are taking the problem in the wrong way... Did you look once at the query sent to the database with that kind of formula? It will perform poorly and you are trying to have OBIEE doing the job that…

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…