Thanks for changing the description Marcelo. We will follow up on this idea when we have a chance to review.

Marcelo, I just confirmed that the current behavior is as designed. Since the argument could be made that overriding the SA format would be useful, I would recommend that you please change the description of the Idea to allow formatting for Subject Area Dates in Workbook Canvas - and I will submit for review. Thanks, Luis

Hi Marcelo, You found the same thing I just found - the option is not showing up for Subject Area dates that are not created as datasets. I'm asking Dev to see if this is as designed or if you found a bug. The workaround would be to make a dataset from the subject area. I'll check back in after I find out more. thanks

Hi Marcelo, That is strange. Have you tried any of the other dates in the dataset or another dataset with dates? What is the source? My guess is that it could be something specific to the dataset - I just tried several datasets with different types of dates and can see the dates. Please try other dates and maybe other…

Marcelo, If you drag the date to a canvas and click on it - the properties panel on the lower left hand side has a tab where you can customize the way the date is formatted. Would that not meet your requirements? If I'm misunderstanding, please provide more details. Thanks.

Thanks Marcelo - I have changed the status to Under Oracle review - we will consider it as a new feature and we will keep you updated if this progresses. Regards, Luis

Hi Marcelo, Thanks for the submitting the idea. I can see the regular expression capability being useful in the expression filters, with a similar syntax to this: REGEXP_LIKE (first_name, '^Ste(v|ph)en$') Or where you thinking of something more complicated. Some examples of how you would imagine this being used would be…

This feature is being considered for a future release. Will keep you updated once we know when this is scheduled.

Rob, You are correct - in addition to supporting hierarchies in Semantic Modeler, they would be useful if users could define them during dataset authoring in DV. That is the feature that is under review. Thanks, Luis

This feature is under Oracle Review. We will update the status once it progresses. 

This feature has been implemented and is available in the January 2022 release of OAC. Documentation can be found here: https://docs.oracle.com/en/cloud/paas/analytics-cloud/acubi/configure-dataset-using-column-properties.html Regards, Luis

This Idea will be address as part of the implementation of https://community.oracle.com/customerconnect/discussion/549540/set-canvas-filter-values-based-on-repository-variables which is an active project and is currently being worked on by the Development team.

We have a story for this requirement and it is currently in the Development team's backlog.

This is currently an active project and being worked on by the development team, but we don't have an ETA yet.

Please review this video for a potential workaround and let us know if this allows you to accomplish the immediate requirement while we review a feature to address it. https://youtu.be/Ot3hnI1sIzY. Oracle Analytics : How to Filter a Canvas on Results of Another Viz/Canvas This video shows how to leverage a simple trick in…

Hi Matti, Thanks for submitting the idea. This is a good suggestion. Question - What is the current default encoding of your files? Are you able to share one? Thanks, Luis

Hi Sumit, Dataset creation has been improved in the current versions of OAC/OAS - although only 100 rows are displayed in the Data Preview, the underlying random sample is 5000 rows. There is also a way to add filters on each of the tables that make up a dataset. There is one known limitation in the Grouping function if…

Hi Gautam, Regarding the second request, would you be able to provide some details or better yet examples of the use case. Thanks, Luis

Hi Angel, Just an update on this idea - we believe that the new sorting capability, we are adding to the metadata view which will allow sorting by Column Name, Treat As, Aggregation Type, and Hidden Status which will be part of a release later this calendar year, will satisfy the requirements of this idea. Once we are able…

Transform Editor Search Pic