Oracle Analytics Cloud on Kyvos

Applies to: Kyvos Enterprise Kyvos Cloud (SaaS on AWS) Kyvos AWS Marketplace

Kyvos Azure Marketplace Kyvos GCP Marketplace Kyvos Single Node Installation (Kyvos SNI)

Oracle Analytics Cloud (OAC) is a Business Intelligence (BI) tool by Oracle Corporation. Its proven architecture and common infrastructure producing and delivering enterprise reports, scorecards, dashboards, ad-hoc analysis, and OLAP analysis provide a rich end-user experience. Kyvos supports connection to OAC, enabling faster insights.

Important points to know

The semantic modeler tool is not available in the OAC professional edition. You must use the enterprise edition if they want to use it.
Users cannot switch the semantic model or connection. Using the Oracle administrative tool, you must import new/updated semantic models into the repository.
OAC local subject area holds only one uploaded repository at a time. So, users can use only one repository at a time, and one repository can contain multiple semantic models across multiple folders.
You cannot create hierarchical and folder structure in OAC. Also, you cannot create hierarchies levels using existing fields.
Dates present in the Kyvos semantic model are treated as string in OAC.
Measure format defined in underlying data source will not reflect in OAC.
OAC did not send any queries to Kyvos for total and subtotals. OAC handles its own.
If users made any changes like field (rename, addition, deletion, calculated measure creation) in the semantic model after the repository is published on OAC then user must load the repository again with the updated semantic model and publish it on OAC. Otherwise, query will fail.
Kyvos sort order functionality not supported on OAC

Connecting and browsing Kyvos semantic model data in OAC

The OAC Business users can connect and browse Kyvos semantic model data using Microsoft Analysis Services Via XMLA Connection to uncover new insights and make faster, more informed business decisions by offering agile visual analytics and self-service discovery together with best-in-class enterprise analytics.

The OAC repository contains all metadata of the BI Server and is managed through the administration tool. It is used to store information about the application environment, such as − Data Modeling, Aggregate Navigation, Caching, Security, Connectivity Information, and SQL Information. To connect the Kyvos semantic model data, you must create an OAC repository for the semantic model, and then you can start browsing it through the OAC application.