Oracle Analytics Interactive Demo
The submission of Oracle for the Yearly contents held by Gartner, where multiple BI Vendors can analyze the same (public available) data-set using there own Analytics Software.
Short feature video (also available on Youtube):
OAC Blog: https://blogs.oracle.com/analyticscloud/
Blog series on machine learning with OAC: https://blogs.oracle.com/analyticscloud/machine-learning
iTunes Podcast: Oracle Analytics Advantage
The web modeller or Thin Client Modeller was introduced with BICS and OAC respectively, to allow a more agile metadata modelling. The thin Client modeller does not provide the same level of modelling functionality compared to the “classic” .rpd metadata model. Additionally, with the current release of OAC only one modelling approach is supported. Thus, only the thin client model or the classical model can be deployed as metadata at a time.
Hence, the might be a scenario for switching from the thin client modeller (web modeller) to the classic .rpd model to support more complex metadata modelling.
A .rpd file can be generated from OAC when downloading a Snapshot and extracting the .bar file. The .bar file can be downloaded from the Snapshots area of the OAC Console:
When clicking on a option menu right to the Snapshots, the Console allows to download the snapshot as .bar file. Once the .bar file is downloaded (after assining a password to protect the downloaded file), the file can be opened with a Archive Tool such as 7z.
The .rpd data model can be opened like any other classical metadata model using the BI Administration Tool. This will contain system generated Objects and Names:
The Protecting Filters Option in Oracle BI or Oracle Analytics Cloud is usually not used or needed. However, it may be required when using multiple Filters on the same Column (Subject area Field) and using Action Links as Drill-down navigation or in conjunction with Dashboard Prompts.
The following is an example scenario without protecting the Filters: On the Detailed Report, the following Operators are defined:
When making the Drill-down from the Top Report using the Action-link Drill-down navigation:
The Filter Operators are overwritten by the internal Background process for navigating to the Detail Report (compare Operator which is “is equal to / is in” which should have been “is less than or equal to” from Report definition):
After selecting “Protect Filter” the Operator is protected from the Background navigation process and the intended Operator is used on the Detailed Report:
This feature is also described in the following article: