Have you tried to modify the metadata in your repository in order to create the outer joins that you require?

silly question but can you log on to OBIEE with the weblogic credentials you're using in catalog manager?

then you'd need to look at an older OS like Windows 7.

If you have Lightweight SSO configured, ClientSessionExpireMinutes is ignored. You need to additionally set LogonExpireMinutes within the <Security> tag in the instanceconfig.xml file https://support.oracle.com/epmos/faces/DocumentDisplay?id=2326019.1

Have you checked the Node Manager, Admin Server & Managed Server logs as well? Have you tried uploading an empty rpd to see if it is an rpd issue?

Which WLST command did you use to import your BAR file?

Is this an upgrade or a fresh installation?

Have you checked your log files? check the Java Host , Presentation Services and the BI Server log files and post any errors you see here if required.

There's a 12c usage tracking BAR file in the <Oracle_Home>/bi/bifoundation/samples/usagetracking directory

Which version of OBIEE 12c have you upgraded to?

Snap!

Have you tried applying the conditional formatting on the result column?

are you running this on windows or linux? Linux runcat.sh -cmd report -online http://localhost:9704/analytics/saw.dll –credentials C:\creds.txt C:\Temp\Analysis_Output.txt -type "Analysis" -fields "Column" "Table" Windows runcat.cmd -cmd report -online http://localhost:9704/analytics/saw.dll –credentials C:\creds.txt…

several ways to do this: * archive/unarchive * BI Application Archive (BAR) file * catalog manager (copy/paste)

As far as I know, there aren't any methods in the webservice to do this. You could automate the method I suggested by doing this by command line using the runcat CLI. You'll probably need to encompass this in a python script to pass analysis name as a parameter and filter out what you don't need in your final output This…

Does it have to be a web service? You can get this information out of a catalog manager report: Although you'd need to apply filtering by analysis (name) in Excel or DV

Have you tried replacing NULLs with Zero - use a CASE statement to achieve this? This would make your running sum work although it should be noted that zero and NULL aren't the same.

Have you looked in the <OBIEE_HOME>\instances\instance1\bifoundation\OracleBIServerComponent\coreapplication_obis1\sample\usagetracking directory (if my memory serves me correctly)?

Which version of OBIEE 12c are you running? tnsnames.ora file is in a different location in 12.2.1.4 & higher

You can update your repository very easily following this tutorial below: http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/bi/bi1116/ut/ut.html Rittman Mead have anopen source enhanced usage tracking dashboard:…