Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Comments
-
We are working on REST APIs for catalog objects. Current Connections have support -- similar to your request (albeit not the same). This is worth looking as for connections as we make more progress on these scenarios. https://docs.oracle.com/en/cloud/paas/analytics-cloud/acapi/api-catalog-connections.html
-
@Gianni Ceresa did a good job describing factors and an approach. And having OAC in the same region as your main data sources is typically beneficial.
-
Role-based filters for datasets can achieve a similar capability if you have some data you can use for the behavior you are after. https://blogs.oracle.com/analytics/post/ensure-consumers-of-your-datasets-only-see-data-relevant-to-them-by-using-the-role-based-filters-feature-in-oracle-analytics-cloud…
-
One option is to use the Metrics monitoring in OCI for query capacity. https://docs.oracle.com/en/cloud/paas/analytics-cloud/acoci/administer-services.html#GUID-F6D90D87-BDBB-49F3-8E54-322F9A4C1E31
-
A potential work around is to create a measure from the attribute and then use that for the conditional formatting or cross row formatting. Also you can use icons too now https://www.youtube.com/watch?v=IrnnJgP__Qg
-
Is using RSUM as a calc in this scenario a reasonable work around?
-
Do you want these to be multiple tables -- each with different sets of columns?
-
In general, it is better to not have multiple sets of jobs for data replication but to have them run as one set. What is the scenario for sequencing them?
-
We don't have an approach for data replication jobs. For data flows, you can review Gabrielle's new blog. https://blogs.oracle.com/analytics/post/oracle-analytics-data-flow-notification-system
-
@Marcelo Finkielsztein for the API/coding approach we can definitely help and we can update the documentation/blogs based on working with you on it.
-
@Sean McArthur for the comment on edit definition -- you need read access to a connnection (that is the ability to use it) to edit definition. You don't need the ability to modify a connection to use edit definition. If you are seeing something else, let us know. For the overall topic - we looking at options.
-
This is useful!
-
Note -- in addition to changing the visible name, you can also create a new dataset and use the "Replace dataset" function in a workbook. If you have a lot of workbooks using the same dataset, this may not be a good work around.
-
I can't think of a reason this should happen. I can reproduce it for my OAC as well. [Update] -- it is actually working as expected. The difference is that the export to excel works for just one visual. When you select the visual in the canvas ... this let's the export button in the chrome know that you are able to export…
-
CSV is a view of the data in a simple row/column format. Can you create an example from sample data of what you are looking for? The purpose of supporting excel format is to allow things like a pivot table.
-
You can do this today in the dataset if the formatting applies to all of your workbooks. Have you tried this approach?
-
Thanks Dan. Understood. Right now there are still things you will need to do with the command-line or admin tool. Semantic Modeler is a work in progress!
-
There are couple of options. For a specific failure you can setup a filter: This function generates a new filtered measure from the given measure and the given filter expression. FILTER(measure USING filter_expr) measure is the name of a measure column. filter_expr is a filter expression. Example: FILTER(revenue USING…
-
A work around for a popular workbook would be to create a copy of the workbook (for example with Save As) and put it in the new folder and then change the existing workbook to have a pointer and some text about the change. Of course, for moving a large number of workbooks -- this would be a lot of work.
-
You can do this via the share menu now. Share a Workbook URL with a Specific Canvas Selected (oracle.com)