Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Comments
-
Thanks for sharing this. Can you let us know which version of OAS you’re on? Is it OAS 2025? There were some known issues in earlier versions with how Semantic Modeler shows logs for actions like deploy/import/export. We have fixed those issues, though I’ll need to check if those updates made it to OAS 2025. We have…
-
Support for Databricks in Semantic Models and Semantic Modeler is planned for calendar year 2025.
-
@Michal Zima I appreciate the details. My response is with respect to the OP concerns regarding unable to use VPD, row level security and "Provide the ability to execute a post login connection script to allow setting contexts…". Regarding the need for a static variable for a connection descriptor, the same is accomplished…
-
@Michal Zima Connection Pool definitions can reference variables in the "Connection Scripts". Connection definition has been separated from Connection Pool in Semantic Modeler with external system connections. This avoids one of the significant challenges we had with the need for updating the connection username / password…
-
@Juan Flores-190415 For the scenario of using Oracle Virtual Private Database (VPD) and data level security, have you tried setting the session context in connection pool using Run on connect, Run before query. This is discussed here:
-
Please find above screenshots for exporting Classic analysis data.
-
Yes. 09-2022 OA Tech Talk - OA Semantic Modeler - Multi User Development with GIT Integration - Oracle Video Hub
-
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. In classic home page or classic catalog, for an analysis, click…
-
@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…