Users should also look at the 'Analytic Views' (AVs) functionality of Oracle database. It simplifies analytical reporting significantly. There is no need to create Summary table or MVs. BI Data Model (including hierarchies, attributes and measures) is pushed inside database. All data exists at all levels of all dimensions,…

Bret, Thanks for your reply. I looked at this YouTube video before starting my work. You maybe able to replicate the issue that I am having. 1. Create a new repository and select 'Oracle Analytic View' as source. 2. Import 'Analytic View' from your database. In my case, it is in my Oracle Autonomous database cloud. 3.…

Hi Pete, Sorry for late reply. I did use 'Oracle Analytic Views' as Connection Type when I added new database in Physical layer. It still shows 'Oracle OLAP' during Import Metadata step, and also ask for some URL. I am now thinking about creating regular sql views on top of ATTRIBUTE DIMENSION hierarchies, and ANALYTIC…

Some examples First Day of the CURRENT Month: TIMESTAMPADD( SQL_TSI_DAY , DAYOFMONTH( CURRENT_DATE) * -(1) + 1, CURRENT_DATE) Last Day of Current Month TIMESTAMPADD( SQL_TSI_DAY , -(1), TIMESTAMPADD( SQL_TSI_MONTH , 1, TIMESTAMPADD( SQL_TSI_DAY , DAYOFMONTH( CURRENT_DATE) * -(1) + 1, CURRENT_DATE))) First Day of the…

Was there any data for the Person who did not receive email?

Thanks Wayne After reading your second answer, I tried to create a new connection in OAC Desktop using 'Oracle Applications' and for HOST I entered my oac cloud instance url (first part is hidden here): https://xxxx.analytics.ocp.oraclecloud.com/analytics but I keep getting error: INVALID HOST NAME Why does it give this…

Federico, Thanks for your reply. I was able to make it work. Looks like even if we define a datamodel/dataset using logical sql query, the bursting query cannot be defined as logical sql query. Bursting query has to be a SELECT statement from a direct physical database. So I created a new table "DELIVERY_CONTROL" in the…