There is an Oracle Support document (How To Implement Data-Level Security In Oracle Analytics Data Visualization Data Sets (Doc ID 2396406.1)) that references this solution for data-level security: "The recommended approach is to use the Enterprise Semantic model for data-level security (row-level) to be applied to a data…

Happy New Year! It is not possible to do a full outer join in the data diagram... just add facts or extend dimension. Your best way to do a full outer join would be to create a Data Flow. Within the data flow you have the most flexibility to join, merge and/or branch your data sets to give you exactly what you need. These…

Only in a pivot table, not a regular table. From the lower left-hand configuration menu, select / deselect "values", "columns" or even "rows" if you would like. (see attached capture). Brian

I guess it depends on your use case and where you are trying to define this constant start date of the 15th. What function or expression are you using that gives you the default start date of the 1st as a reference? You can use constants to include specific dates in expressions: DATE [2020-11-15] or TIMESTAMP [2020-11-15…

We are not using SSL, but our connection DSN is "http://Essbase-IP-address/essbase". We do not have to use the port or /agent suffix. Brian

Hi Brian, You will need Enterprise edition as you will connect to EPM through the ADM driver within the RPD for Business Intelligence. Once you do that you will be able to report from BI & DV from the resulting Subject Area. Otherwise, you will have to do data extracts to stage in a database and then connect to DV. Brian

To purge the cache manually, use this command in the "Issue Sql" in the Administration Console: Call SAPurgeAllCache(); * and make sure to uncheck "Use Oracle BI Presentation Services Cache" There are also additional purging options by DB, table and query... as well as continued reading about developing your cache…

Hi Rehan, Aman provides a good description of the tools and what they accomplish. For your particular use case, you will want to use Data Sync connected to ADW to synchronize your data to the cloud for batch processing needs. If you need a more real-time replication of on-premises data to ADW, then I would explore the use…

Chethana, I would try and populate your null values with an "inactive" value through a data flow or data prep case statement to handle that count for you. Brian

Hi Chethana, If you do not want to create an action off of the data, you can also create a link for informational purposes only utilizing the Text box component and creating the link within the message of the text box. Thanks, Brian