Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Comments
-
Michal -- can you give an example? You can use logical sql to initialize a parameter. That logical sql can reference a dataset. Would that work?
-
We are investigating how we can add an alternative sort column. For now the work around is to add the column to the visual and set the sorting on that extra column.
-
Have you considered data actions for this scenario?
-
To understand a bit better, you want to pass the hierarchy as an object and then set the value/level in the destination. Is that right?
-
Try using the classic catalog permissions per Subject Area. Deny to the groups which should not be able to author. Administration Security -Manage Privileges Manage privileges and rights given to users and groups. The path is <OAC URL>/ui/analytics/saw.dll?Admin
-
In the September release, we added an option to "go right to editing" the metadata. The profiling and recommendations will still happen but move to the background. Many sources are fast and this is not necessary but some sources or tables take longer to profile and this can help.
-
It is not clear if you followed all the steps. Any more information about what you did -- how you got the URL, if you applied the client updates, which version of PBI desktop you are using?
-
Assuming you are using a dataset, to trouble shoot, I would create a new dataset from the tables and see if that has the old information. If it does, then it is likely something in the DB. IF that does work -- it is not clear when Live would not get the latest information. Be sure all tables in the dataset are set to live.
-
The message is saying the query it taking too long. If your report creates a query that is too slow from the source system - you can try creating separate charts or you can see if adding a filter such as per employee is sufficient. For example, make a list of employees and then have a drill through or details chart with a…
-
We definitely have customers that build analyses like these. You have a few options. First -- you can put the raw data in to its own dataset or table. Then you can build calculations off of these data points. Depending on the calculations -- data flows can help. They are especially useful for changing the grain of the…
-
At the moment you can hover over the Oracle Analytics in the about box.
-
This seems like an idea -- could you post https://community.oracle.com/customerconnect/categories/idealab-oracle-analytics-cloud-and-server
-
You should create an SR. If you have deleted an instance or let your tenancy expire -- the OAC instance should no longer be available. You should work with support to determine your options.
-
We are working on APIs to allow you to automate this scenario. https://community.oracle.com/customerconnect/discussion/510521/api-for-oac-snapshots
-
The Union functionality currently has this limit. In your situation --you may want to try creating one datasets with multiple tables or use blending. In data flows today - the Union operator is trying to create a fully denormalized data table in the flow. The other option you have is to add and select columns to each side…
-
This looks like a general database tuning situation. The numbers might be a bit misleading as the query time is 0 which is unlikely. In this case -- I would start by running the same query generated by OAC against the database directly and seeing how long this is taking. To get help with trouble shooting here you can open…
-
There was an update to JET in 6.0. We will investigate if there is a tweak you will need on the javascript side.
-
This sounds useful! We will look at UX options here.
-
Also there is a preview API for reloading data after an ETL process via API. https://docs.oracle.com/en/cloud/paas/analytics-cloud/acapi/op-20210901-catalog-datasets-datasetid-actions-reload-post.html
-
This looks like the idea is in the wrong section. This looks like a request for Fusion/BICC to add a column to a PVO. These are not controlled by Oracle Analytics Cloud or Server.