Is there row-level security on your underlying database? Have you checked the SQL that OBIEE generates? Have you run that directly on the database as the user defined in the connection pool?

12.2.1.4 is certified to run with SQL Server 2016. 2017 isn’t certified therefore it won’t be supported if you run into any issues even if you’re able to get it working. You can check certifications on the support.oracle.com site on the certifications tab.

Check this in offline mode as well.

By Data Model, do you mean repository or are you referring to an OAC Data Set? Have you created an Amazon Redshift Connection?

It depends on a number of things. Do you have a proper time dimension? Is this being implemented in OBIEE? Typically, you'd need to use the TIMESTAMPADD function TIMESTAMPADD(SQL_TSI_MONTH, -1, add sales month date here)

I'm afraid that you need an Oracle Support licence to access this document and as a result, I can't share this unfortunately.

I'm assuming that this is with OBIEE? Which version? This can be done with Conditional Formatting -

Have you enabled BI Publisher logging? As you didn't mention your version, use this document to configure logging: https://support.oracle.com/knowledge/Siebel/2076111_1.html

Have you executed the code on the command line? If the syntax is correct and the command runs then you should be able to script it.

I can’t see what the OBIEE issue is here unless I’m missing something obvious.

I'm not too sure if what you are after is a means to schedule BI Publisher reports to be delivered as email. If that is what you're after then take a look at these links which describe how to set up an email server in the BI Publisher configuration and also how to actually create a BI Publisher job that will schedule your…

Adding to @Gianni Ceresa's row level data filtering suggestion, you'd also need to add your PRODUCTS table as an additional Logical Table Source in your COSTS logical dimension. Once you've done that, then the data filtering should fit your use case.

You could create a 2nd Analysis which returns the "Prod Id" subquery, then apply it to your main Analysis in the filter as below:

Look at this excellent article written by @rmoff which elaborately describes how to automate the deployment of OBIEE artefacts.

The document clearly states all the steps needed in order to modify the user session timeout.

Check this article out -> https://support.oracle.com/knowledge/Enterprise%20Performance%20Management%20and%20Business%20Intelligence/2469424_1.htm…

What you’re asking for doesn’t exist I’m afraid. The closest you’ll get is a 3rd party tool that exposes OBIEE subject areas in Power BI - https://www.biconnector.com/visualize-obiee-data-in-power-bi/

Then I'm not sure that you can achieve this technically.If you are trying to connect to the underlying Google Analytics data then you can do this using Oracle Analytics Desktop/ Oracle Analytics Cloud or Oracle Data Visualisation (which is part of OBIEE).

Are you trying to connect to some visualisations that are in Google Analytics from OBIEE?

I would strongly recommend that you push this logic to the data source. You can use ETL (worst case scenario, a view) to implement your logic and OBIEE just pulls data from one object.