Currently, a VM is required for client tools installation. The command line utilities to convert SMML to RPD and deploy the semantic model are available in the client tools. Equivalent functionality using REST APIs in Oracle Analytics Cloud is in the roadmap.

Is this question specific to OAS? The suggestion earlier is for OAC.

Yes. It is available in OAC Sept 2024 with Remote Data Connectivity.

LSA icons updated.

Git services in private network should work in OAS. Errors and details will help. Documentation will be updated with the same information.

If the report is first opened in Answers, the query runs twice because the FETCH FIRST N ROWS part is different for rendering the report and downloading. This is due to various data limits in OAC. One limit is for rendering, and the other is for downloading. If the report is exported from the Home or Catalog page, then…

@Rudy Hruska Semantic Modeler does allow specifying connection scripts for Run on connect, Run before query, Run after query, and Run on disconnect. You can alter the session to run on connect to set session context.

This feature is in the roadmap. We will provide an update as soon as we have a timeline.

We have noted the request for a new feature. What data sources do you use in Semantic Model. If you use only relational sources, migrate to Semantic Modeler. Semantic modeler is a web-based modelling tool within OAC and supports MFA. OAC supported Data Sources Matrix for using semantic modeler:…

If you upload a semantic model (RPD), access to OAC Data Modeler will get disabled. OAC Data Modeler can only access models created with the Data Modeler. Models created with Admin Tool may include advanced features like aggregate navigation, fragmentation that are not supported in Data Modeler.…

Please share the use case. No in short term plan.

What is the version of Oracle Analytics Client Tool (Model Admin Tool) you are using. What is the database? ADW? Are the MVs created by the same schema owner as the other database objects like Tables and Views that you are able to import?

Connecting to a Semantic Model in the cloud is not the same as online mode where you are working on the deployed model directly. It is a pull, edit, push mode. When opening a model in the cloud, the semantic model is pulled from the cloud and stored in temporary rpd file locally. From there on all the development is done…

Thank you for posting your idea. Datasets can be exported and imported as part of Workbook (Project) export. When a Workbook is exported from a Dev / Sandbox environment, all datasets used in the project are exported and the same can be imported in Production environment.

This is currently in the plan.

Thank you for sharing this idea. If you are seeing stale data, there are a few options to purge cache without having to see the list of cache entries. You can purge the cache by query, table, database or purge all cache. You can find more details here.…

@Marcelo Finkielsztein You can accomplish the same using an EVALUATE function with a database Function. Syntax EVALUATE('db_function(%1...%N)' [AS data_type] [, column1, columnN]) Where: db_function is any valid database function understood by the underlying data source. Example for Oracle Database…

Yes. For OAC, It is planned in H1CY2022. The subsequent annual release of OAS will have this tool.

This feature is available in OAC August 2021 (6.2) update.

Yes. With Semantic Modeler, you can assign permissions and data filters for application roles already created in OAC console and no need to create Application Roles again or synchronize application roles.