They could still add a "Best practice violation" in the consistency check of the RPD, so they can perform the test only when Oracle is the database. Let's say there are ways it could have been added, they just didn't

I'm still not sure why by default it isn't enabled as it avoid many issues as soon as multiple schemas are involved. You can assume that on an Oracle database you can check that checkbox by default as it will avoid you issues in the future (and so far I didn't find issues in always enabling that).

I doubt the Autonomous Database is certified for the RCU. You don't have SYSDBA access on an Autonomous Database and this is what the RCU checks for and need to do the job. You can use Autonomous as a datasource, as you do in your OAC, but you don't use the autonomous for the RCU in OAC as you don't have access to the RCU…

Your year/months are dimensions, so you duplicate the measure you currently have and one you keep it as it is, the second one you do the "show value as...". The 2 measures (the same one in double) goes in measures, and you then move the "Measure Labels" in the Columns part and you place it after the month (so the 2 columns…

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.