You don't need to touch OAC at all, it's just exactly the same process (as OAS is "almost" OAC but on premises). In OAS you login in DV, go in the main menu and open the Console, from there you have the Snapshots page where you can upload your BAR of 12c. It isn't at all into Weblogic, it's into the tool itself (because in…

Didn't you find the official doc? https://docs.oracle.com/en/middleware/bi/analytics-server/migrate-upgrade-oas/index.html You mention OBIEE 12c, which doesn't mean much as there are many versions of 12c. The doc is explicit: upgrade to 12.2.1.4 and from there to OAS with an in-place upgrade which will bring with it all…

As said, an Excel file isn't a "shared" storage by default. It's a file coming from a user and loaded "one-shot" on the server. You can update it, but the action is you reloading the Excel file. You can't expect OAS to be able to come and read your file automatically all the time, because OAS isn't allowed to read things…

Hi, Oracle planned to cover OAS in the same place as OAC, in the other "forum" : https://cloudcustomerconnect.oracle.com/resources/0591c7239f/summary It sounds strange the requirement of "import data from BI Publisher into DV" mainly because Publisher doesn't store data but, just like DV, supports connecting to various…

Hi, What do you expect to be the result of such "flag"/attribute/designation? A source is a source, OBIEE doesn't care much what the source is. You have all the various settings available to set some attributes based on what the source and how you want it to be used, but OLTP or not doesn't change anything for OBIEE.

Hi, If you want to at least have a chance to get a reply, you maybe want to look at You must invest some time and efforts in writing a question, or why would people invest their own time guessing everything you didn't want to write? Basic things like exact detailed version and bundle patch of your environment (did you ever…

Deepak_R-Oracle wrote:... it just checks whether the account in active status or not. Oh no, it needs to access those schemas for real, it's not just a fake test if account is active or disabled.

SonPat99 wrote:What will be the impact if I am following this? You will be changing the behaviour on the whole system. 'A' isn't 'a', if they would be the same why didn't your ETL fixed that by either turn everything uppercase or lowercase? The sort you asked here isn't the normal natural sort : things are sorting in a…

The following is just random guesses .... That SMTP message would make me think that the SMTP server simply didn't recognize your client as a valid user allowed to send emails. In the past (15-20+ years ago) many SMTP were just fully open: anyone could send emails around easily. That's how to make life simple for spammers.…

It isn't the "COLUMN_TO_BE_DISPLAYED" that you must to sort, but you aren't using this column in your analysis. You must create a new column in the RPD containing the full link, the whole piece of HTML, and that one is the one to sort based on the technical column you created already.

Not directly on your topic but related to... You don't need your OBIEE to be SSL to connect to a SMPT via SSL. In this SMTP connection your OBIEE acts as the client, therefore the SMTP will never know if your OBIEE is SSL or not etc. You said you tested with various certificates and even a self-signed one : that's not how…

The sorting column, your COLUMN_TO_BE_DISPLAYED, which you transform either all upper or all lower case, is not going to be visible. It's a technical column in the RPD, you use for sorting your link column and that link column is the one you will expose in addition to the existing content of the subject area. Setting a…

The UI gives you 2 options for sorting: ascending or descending. What you ask is, for that given column which is a custom formula, to have another kind of sort based on rules you set yourself. Obviously you can't get that "for free". The hidden column Jerry mentioned is the way to go for these situations. If you want to…

In extension to Jerry's answer, if it's an OBIEE analysis somebody maybe missed the point of modelling there. There are facts and dimensions and that's what make a model powerful as it can be used in various ways.

That's more a good practice than a bug : if you don't filter extremely well the definition of your users in the AD integration any user with valid AD credentials will end up being a BI Consumer. Removing authenticated users from any inheritance is normal in any setup (when you care about security). Still the bug isn't…

What about following the official doc or some MOS notes? (there has been quite a lot written on AD authentication) Keep it simple and stick to "certified" sources as they exists.

From a logical point of view @Jerry Casey option is better: why do you want to bother the system with EVALUATE when the native OBIEE functions are enough? From a business point of view, that's something you must have directly in your database. You can't trust the front end, every single analysis to always obfuscate credit…

So could you please say which exact tool/product (with version etc.) is it about? In this way a MOD can look at moving the thread in the right place.

Are you talking about OBIEE? Because you posted in but not sure if you really talk about OBIEE here ...

I would say your only chance would be to look in how images stored in the DB can be displayed. Your blob isn't a PDF, it's a bunch of 0 and 1, that's it. Your browser understand that a URL is a PDF thanks to some headers telling what is the time of the content it's about to receive, so you would have to go through…