My suggestion would be to extend your time dimension and add 2 attributes to hold these first date last year and the same date last year values values. This should make your calculation a bit simpler.

First question; is f.column a fact or attribute? If it’s an attribute then you should consider moving it to a dimension.

This document is for OBIEE 11g but it should still apply to 12c. I will suggest that you rollback the changes you made and then carry out the changes using the document above.

Have you tried this in other browsers? Are there any errors in the log files? Have you also run this through you browser’s developer console?

Have you checked your scheduler log files for any errors?

Next questions. Does the DV canvas display correctly on the dashboard? Have you looked at your log files?

Can you clearly state what steps you took to add your DV canvas to a dashboard and also how you scheduled email delivery.

Hi @OracleUser_IP06I It’s quite simple really. You need to have a dashboard prompt for the State attribute in your case and this should have a presentation variable associated to it. This presentation variable should have the exact same name as the BI Publisher report parameter for the State attribute. Take a look at this…

Have you looked at your log files? Have you tried another browser? Have you tried clearing your browser cache?

The ideal solution to this problem would be toextend your time dimension with these attributes. You could have a flag on the date row so that if the date is a weekend or weekday, this will be flagged appropriately or you could have another attribute that tells you the next working date. If the day is Saturday for example…

My first suggestion would be to consider an upgrade to Oracle Analytics Server where map layers are much easier to implement and to use. Take a look at these documents: https://docs.oracle.com/middleware/1221/biee/BIESG/configmap.htm#BIESG1340…

As it states, you can't nest aggregate time functions. Your best bet (if possible) would be to calculate this value either as part of your ETL or store it pre-calculated in your data source and pick it up in your ETL. Once in your ETL, you can load this into your fact table as another fact.

I would strongly recommend that you take a look at this tutorial which should walk you through the process of creating a BIP report. https://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/bi/bip/bip11g/gettingstarted11116/gs.htm

The default Oracle DB package as the name suggests is a property that defines the name of a package in the schema of your default data source that you want to execute event triggers. https://docs.oracle.com/middleware/12211/bip/BIPDM/GUID-890FCA3E-24EE-425B-A65B-76BAF98C1C1B.htm#BIPDM135

To add to @Christian Berg's points, you may also need to look at the ordering of your Authentication Providers as this determines the authentication route taken by weblogic.

The best way to look at it is as Visual Analyser being the predecessor of Data Visualisation. The Data Visualisation URL is normally in the form of server:port/dv/ui

Oracle will probably tell you to upgrade to 12 before they look into this. Have you tried other machines, other browsers, clearing browser cache etc? Have you also taken a look at the log files?

The ideal way to do this is to have a date/time dimension that has all the date attributes you need to capture like the previous quarter, current month, current year, week number, the list goes on. If these are all pre-calculated then you can just use it rather than attempting to evaluate these at runtime.

What happens if you pull the physical SQL generated by the BI Server out of the NQquery.log file and run the SQL directly on your database?

What happens when you place this CASE statement column in an analysis? Does it return any data?