Categories
Allow formatting for Subject Area Dates in Workbook Canvas
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
Comments
-
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.
0 -
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 !
0 -
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
0 -
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!
0 -
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
0 -
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!
0 -
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
0 -
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
0 -
Thanks for changing the description Marcelo. We will follow up on this idea when we have a chance to review.
0
