https://community.oracle.com/products/oracleanalytics/discussion/comment/61839#Comment_61839 What aggregation type have you selected for Hours?

Hi @User_RD03L, Please try the following: CASE WHEN ("Reported Time Entry Details"."Payroll Time Type Name" = 'Public Holiday IN' AND "Reported Time Cards"."Reported Hours" IS NOT NULL) THEN CAST("Reported Time Cards"."Reported Hours" AS CHAR) WHEN ("Reported Time Entry Details"."Payroll Time Type Name" = 'Public Holiday…

Hi @User_RD03L, Can you please add "Reported Time Entry Details"."Payroll Time Type Name" in the above report and send the screenshot as suggested by @gclampitt , it will help to understand the data points and will be helpful to code accordingly. Cheers,

Hi @User_RD03L, Can you please try the following to see if there's any betterment? CASE WHEN ("Reported Time Entry Details"."Payroll Time Type Name" = 'Public Holiday IN' AND "Reported Time Cards"."Reported Hours" IS NOT NULL) THEN CAST("Reported Time Cards"."Reported Hours" AS CHAR) WHEN "Reported Time Entry…

Hi @Vinoth Mounagurusamy, You can define the column as String and then just take the 'YYYY-MM-DD' part with the help of Substring function and then again cast it to Date. CAST(SUBSTRING(CAST("- General Information"."Invoice Entered Date" AS char) FROM 1 FOR 10) AS DATE) It should only bring the Date part after download…

Thank you very much @Gaurav Bharadwaj-Oracle! Very useful information. Cheers,

Hi @Vinoth Mounagurusamy, I think you need to see the data in 'Data Time Zone'. Can you please check the attached XML / Catalog and filter with your invoice and see which column is giving you the correct data also match back the data with your application data. Ideally in my experience 'Data Time Zone' should be the…

Hi @Vinoth Mounagurusamy, Are you using 'Data Format' tab to define the column as 'Date'? If yes, instead define the column as Date using Cast in the 'Column Formula'. It should not get the time part after download. CAST(Invoice Creation Date as DATE) Hope this help. Cheers,

Hi @Vinoth Mounagurusamy, If your requirement is to show only date part, you can easily achieve by defining the column as Date. Say the Column Name is 'Invoice Creation Date' so in the edit formula tab you have to define like: CAST(Invoice Creation Date as DATE) It'll only return the Date part. Hope this help. Cheers,

Hi @Steph Yeung, You can achieve it using Pivot Table. Place your 'Element Name' in the Column Section and 'Displayed Input Value' in Measure Section. Select some 'Aggregation Rule' for 'Displayed Input Value'. Please find below the screenshots. Pivot View Settings: Aggregation Rule: Table vs Pivot: Hope this help. Cheers,

Very helpful article. Thank you very much @Prasenjit_Thakur-Oracle!

It'll be a very helpful feature to have. Upvoted.

Much needed functionality, it'll add so much values. Upvoted.

Very informative & helpful information. Thanks for sharing @Prasenjit_Thakur-Oracle!

Hi @Kavita Shah, Please take a look into the following Oracle doc if you have not already, it might be useful. https://support.oracle.com/knowledge/Oracle%20Cloud/2758422_1.html Hope this help. Cheers,

https://community.oracle.com/products/oracleanalytics/discussion/comment/60475#Comment_60475 Hi @Dimple-Nagesh-Support-Oracle, Very informative & helpful information. Much appreciated. Thank you very much! Cheers,

Thanks for the detailed info @David Granholm-Oracle! Much appreciated.

It'll be a great feature to have. Upvoted.

Hi @Mohamed Mohsen, You've to control the access to Data Model developer role. It should not be allowed to the end users if they have data view restrictions. It is primarily a get-way to the Database so if someone can get the access the can access all the tables that present in the database like secured or non-secured.…

Much needed feature which will add so much values. Upvoted. Another use case is the Pivot table having multiple measures columns and wanted to rename those grand totals columns accordingly but it seems it is not possible yet.