nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Allow formatting for Subject Area Dates in Workbook Canvas

Marcelo Finkielsztein

Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of):

Postmedia Network

Description (Required):

Please, consider adding formatting to attribute columns on OAC DV workbook canvas.

Use Case and Business Need (Required):

We have attributes (e.g. Date/Time ) among the columns we show in workbooks. Today, we see

09/01/2020 12:00:00 AM

and we do not have ability to format this column.

I see there is some formatting available to measures, but I cannot find a way to format attributes.

Thanks,

Marcelo

Find more posts tagged with

Under Review

Analysis and Data Visualization

Status: Under Review

Comments

Luis E. Rivas -Oracle

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.

Marcelo Finkielsztein

No ( !? weird !?)

It certainly would meet my reqs!!! but... i dont see it (!?)

I am using OAC, release 6.3 as far as I can tell.

I dont get the little watch icon !?!?

what am i doing wrong?

is it that my instance is on "Generation 1" instead of "Gen 2" ??? or some system settings I am missing???

Glad to see the option is there for you !

Luis E. Rivas -Oracle

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 datasets and let me know.

Thanks

Marcelo Finkielsztein

Ahh ... look at this !

This is NOT a workbook built on a "dataset" but on a "Local Subject Area", defined in a "classic" RPD model file that was uploaded to OAC.

If I start a workbook based on a dataset, then I DO GET the option to format dates.

Could anyone else please replicate this and confirm ?

TIA!

Luis E. Rivas -Oracle

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

Marcelo Finkielsztein

Thank you @Luis E. Rivas -Oracle

( only as a personal comment, I will need to think hard before adopting that workaround; I'd rather I did not have datasets hanging around only for this reason. It can escalate to a maintenance nightmare too easily ? )

again THANK YOU!

Luis E. Rivas -Oracle

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

Marcelo Finkielsztein

Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of):

Postmedia Network

Description (Required):

Please, consider adding formatting to attribute columns on OAC DV workbook canvas.

Use Case and Business Need (Required):

We have attributes (e.g. Date/Time ) among the columns we show in workbooks. Today, we see

09/01/2020 12:00:00 AM

and we do not have ability to format this column.

I see there is some formatting available to measures, but I cannot find a way to format attributes.

Thanks,

Marcelo

Title was:

Apply custom format to attribute data shown in OAC workbooks

Luis E. Rivas -Oracle

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