Take a look at section 8.4.1.1 and 8.4.1.2 for information on setting the log level for query logging. You can can do it in a variety of ways where you can set it within a specific report or for a user in Admin tool

I've used the BVT on OBIEE 11.1.1.7.x and it does work. BVT is definitely the tool you need to automate your regression testing.

Hi Narendra As long as it's in the matrix, it should be fine. Regards Joel

check the compatibility matrix here Assuming you're installing 11.1.1.9.x

As far as I'm aware,11g to 12c upgrade is done out of place where 12c is installed on a new server and RCU is run as part of this process (described here - in the powerpoint). As such, the schemas aren't supposed to be shared. You'll need to run the RCU to create new schemas and then run the config.bat/sh utility to…

To add to @Christian Berg, see this blog which describes how to use the PORTALPATH session variable in conjunction with an initialisation block as I believe you require.

Hi @Michael I actually meant when you created the BAR file in your 11g instance, did you stop all 11g components beforehand?

Hi @Machiel Have you tried performing the export with OBIEE 11g components all shut down (Admin Server, Managed Server & OPMN)?

Could you provide a bit more information about what you mean by metadata? Are you referring to the DB schemas created with the RCU?

Have you tried logging on to DB via TOAD/SQL Developer/SQL*Plus from machine which you're attempting to install OBIEE?

Have you checked the BI Server logs (NQServer.log and NQquery.log) to check what SQL is being sent down to DB for both queries? That would be a starting point then you can look at repository based on your findings.

You are correct. You'll need 3 date presentations folders. Sent from my iPhone

The alternative, as mentioned previously by @Thomas Dodds would be to have a simplified presentation layer whereby you'd have 3 measures only. In the BMM layer, you'd also have 3 measure columns only but the logical fact will have 3 logical table sources mapping to the underlying fact aliases in the Physical Layer.…

Try using the sampleapp, this is a virtual machine with everything set up. All you need to do is to download and a bit of configuration and you're up and running. Alternatively, you could log on to https://slc02oks.oracle.com:7780/analytics

Hi @Wij Check your Presentation Services log files. Also look at BI Server log files as well. <MW_HOME>/user_projects/domains/<DOMAIN_NAME>/servers/obips1/logs <MW_HOME>/user_projects/domains/<DOMAIN_NAME>/servers/obis1/logs

In that case, it sounds like you need to delete your WebLogic domain as I don't believe you can re-purpose an existing domain as you've described. You'll probably have to create a new domain and then use the config.cmd tool to attach OBIEE to it.

Hi @1454010 take me a look at the following document which contains a PowerPoint that describes the steps required for migration from 11g to 12c. In in a nutshell, the 1st steps install the 12 WebLogic shell and then "lay down" the BIEE binaries and deploy them to the WebLogic shell. You then apply your 11g export bundle…

Hi @875299, to start off with, could you show a screenshot of the BMM layer data model which displays the joins of the 2 facts and 3 conformed dimensions?

Just to add to @Andrew Fomin. previous post above, you'll need to alias your date dimension in the Physical Layer and for each of the 3 dates, add the corresponding date dimension join between the fact and date dimension alias. You'll then need to add the aliases to BMM layer, hierarchies, logical joins etc before exposing…

You now need to look at errors in the Presentation Services log files - <MW_HOME>/user_projects/domains/<DOMAIN_NAME>/servers/obips1/logs