Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Comments
-
The first idea here -- a lineage view showing data mapping between presentation, business model and physical layer -- can be seen in the Semantic Modeler preview. Try this in the May 2022 release in a dev or test environment.
-
Can you vote for and follow this existing idea: https://community.oracle.com/customerconnect/discussion/535336/ability-to-share-data-flow-with-other-users
-
If you have a set of folders with workbooks pointing to the datasets -- you can create a DVA from the folder and it will include the metadata for the datasets. You can either create DVAs for individual workbooks(with datasets) or the whole folder.
-
What specific approach are you using to manage data security by user? Is this connected with IDCS and groups?
-
Have you tried creating a connection via the Oracle Applications connector?
-
There is an approach for this specific use case -- duplicate the dataset and modify the change the new one. Have you tried that?
-
Quick question on the approach. Assuming revenue is coming from a fact table, would you want all columns from that fact table and the grain of the fact table? For a chart/table like this: Sales Region, Month, Revenue North America, Jan-22, 100K Would the expansion show all the rows in the fact table for the 100K with all…
-
@bbci_BeverlyBaker -- this is something worth investigating. Often slow queries are due to database or data model design. It is usually possible to have fast queries. @andrefecteau -- in DV workbooks and datasets at least -- the user should be prompted to re-authenticate without losing their work. This was added last year.…
-
We are looking at some approach to notifications.
-
In DV workbooks, the charts will use the users locale settings for this. Is that sufficient?
-
Until we have some product improvement -- a work around some customers are using is to use external files with ADW and then connect as a table. Querying external CSV, TSV and JSON files from your Autonomous Data Warehouse (oracle.com)
-
These can be done via a filter expression -- will that work here? You can use more complex logic such as AND (for between) and OR logic. Apply Different Filter Types (oracle.com) Here is an example on a dataset table filter -- and you can use expression filters in project Wookbooks as well. Expression Filters in Multi…
-
@Michal Zima i don't think we have any plans to change "namespaces" for objects. Once they are imported the namespace is really just part of the object identifier. What would changing a namespace do for you?
-
This functionality is available via Private Endpoints. Connecting to Oracle Analytics Cloud Private Endpoint with VPN / FastConnect (ateam-oracle.com)
-
Try using the schedule data reload feature for datasets. Here is a video on the topic. Scheduled Datasets Reload in Oracle Analytics - YouTube
-
Is this for the My Calculations part of a project/workbook?
-
We will be adding richness to the interactivity choices. However, for this specific scenario -- you can accomplish it by moving the filters you want the consumer users to interact with to the canvas. There are visualization controls for doing on-canvas filters. Disable the interactivity (which will hide the filter bar),…
-
Not exactly. Projects use queries which can be to datasets Live queries or automatic caching. If automatic caching is used, you can schedule these to ensure you have data at a specific time such as 6am or hourly for example. Projects when they load will query the source or cache. If the source system is slow, Automatic…
-
Good observation of the user experience issue here. What would be the benefits and challenges of having the blend data just stored with the project (vs dataset today)?
-
These are good comments. We are starting the design work in this area and will keep this in mind.