As a starting point, take a loo at this: https://docs.oracle.com/middleware/12213/biee/BIEIT/methods.htm#BIEIT180

Your best bet would be to look at using Oracle Application Express (APEX) - This blog post describes how it can be implemented.

pleasure

That’s all we can do…

Could your issue be related to this? there appears to be a patch for this: * OBIEE 12.2.1.2.180717 - Patch 27916905: * OBIEE 12.2.1.3.180717 - Patch 27329720: Look at Section 9 of the patch readme document.

I'm sure @Robert Angel will agree with me when I suggest that you create a dimension with a sort column and the CASE statement logic as a 2nd column whee the 1st is used to set the order. The prefix solution is a bit more crude in which you'd append your case statement with A,B,C,D etc to force a sort on based on the 1st…

I’m a bit confused. You mentioned in your original post the following: OBIEE: 12.2.1.4 (Upgraded from 12.2.1.3) Servers: Windows Server 2012 R2 Old OBIEE Home: OBIEE12C New OBIEE Home: OBIEE12_2_1_4 It clearly looks like 2 different directories to me. As I said, the 12.2.1.4 upgrade is done in place so should have been…

Did you follow these instructions? https://docs.oracle.com/middleware/bi12214/lcm/OBIUP/GUID-93B3A0DC-7546-4ABB-946E-593B3AAE444D.htm#OBIUP-GUID-93B3A0DC-7… It looks like you’ve got 2 OBIEE homes. The upgrade should be an in place upgrade where you’ll be upgrading your existing binaries to 12.2.1.4.

That’s what I said in my earlier post. All you’d need is to reload files and metadata.

These changes should be immediately available after reloading files and metadata in the OBIEE presentation services administration screen

It would appear that you're on 12.2.1.3+ in which case, lightweight SSO is enabled by default. Oracle Support Document 2316810.1 (OBIEE 12c: Using NQUser and NQPassword in URL, Fails to Login When Single Sign-On (SSO) or Lightweight SSO (LWSSO) Is Enabled) can be found at:…

I’ll look for some documentation to pass on about deploying a copy of the analytics application in Weblogic. As @Christian said using NQUser & NQPassword in URLs is no longer allowed. https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=291597715648388&parent=EXTERNAL_SEARCH&sourceId=PROBLEM&… EDIT:…

That’s fair enough!

Oracle Support Document 2102444.1 (How To Remove Or Add Specific OBIEE 12c Data Visualization | Visual Analyzer Permissions And Access) can be found at: https://support.oracle.com/epmos/faces/DocumentDisplay?id=2102444.1

First of all, there is no 12.3 version of OBIEE unless you mean 12.2.1.3. You're better off using BI Publisher for letter generation as it has native bursting capabilities. BI Publisher also has the capability to deliver to an FTP location.

Take a look at this document - 12.2.1.3 auto enables a feature for RAC. Unfortunately, if you have a non RAC database, you'll get the issues you're facing. The document gives you a number of workaround options. Oracle Support Document 2308193.1 (FMW 12.2.1.3.0: "ONS configuration failed" or "oracle.ons.NoServersAvailable:…

Is this article of any use? Oracle Support Document 2203639.1 (After Upgrade To OBIEE 12.2.1.2 or higher, Lifecycle Management Commands and datamodel.sh|cmd Commands Fail With Error '[OBI-LCM-00006] File not found: /.../service.xml') can be found at: https://support.oracle.com/epmos/faces/DocumentDisplay?id=2203639.1

I don't see why this is a problem. All you need to do is to pass the Quarter entered in the dashboard prompt into a presentation variable and then calculate the previous quarter using the AGO function .

One way to overcome this issue is to deploy a second analytics deployment in weblogic. This 2nd analytics deployment won't have any of the SSO configuration in it and should allow you to access OBIEE without SSO.

If you have a well formed time dimension that has a corresponding logical dimensions with levels assigned, then you can easily achieve this by using the AGO time series function.