Exactly what Jerry said. You say the layout is important, but you aren't in Excel and therefore you have to go with how OBIEE work in a pivot table. The "Grand Total" will also calculate for the % column and the name of the 2 measures will be visible (as you more than 1).

Why don't you use typical linux tools for that? There are many ways and commands which can simulate a user entering a password when a script/command doesn't have a parameter for it. Otherwise there would be little to no automation at all as many scripts/commands don't have all the parameter you need and are only…

If you look at the certification matrix (https://www.oracle.com/technetwork/middleware/bi/bi-11gr1certmatrix-ps6-1928219.xls ) you see that 12.1 is still certified. So it all depends what your "12c" is for real. And a old tool doesn't always get certified for newer DB versions (mainly because 11.1.1.7 isn't supported…

Did you look at the real query generating the ORA-00942 ? What is the table it try to find? Did you enable fully qualified names in the connection pools?

Rai Qaiser Hussain wrote:Tried with two connection pool also as shown in Fig.1 even updating accurate number of records That's all you don't want ! If you need 2 connection pools, one for dims, one for facts, you are moving the whole load of acting as a database on the BI Server. Do not do that! It make no sense to have 2…

That space as been disabled because, as the message says, it moved to CCC, the "other" forum. It has been a strange decision to close the space here and have one named "General OBIEE" which is actually only about Publisher and almost no OBIEE content at all ... I saw you posted there, so wait and see which thread get an…

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.