06-16-2022 10:28 AM - last edited on 05-23-2023 03:42 AM by JackLacava
In a cube view, the row and/or column sets can be set to Cell Type “Combo Box” or "Date" Time, if Date is chosen a cool calendar and a time display will allow users to select a specific date and time in a data cell, however , the display format is not correct, cell formatting does not work , this this bcs I am using the annotation view?
06-16-2022 12:03 PM
Hello,
What happens when you try number format MM/dd/yyyy with view "Periodic" and view "annotation"?
06-16-2022 12:19 PM
Hi Bharti
well.. If the period is closed the cells get locked., if period is Open, the combo box is not available anymore and the calendar format MM/dd/yyyy still does not work
07-27-2023 01:51 PM
I'm sure you figured this out by now but for future readers I'll respond. I had this exact same issue today. I think it's because the Cell Type of Date doesn't like the view of Annotation. I needed the rest of the cube view to still be Annotation so in the member filter for that date row I put a view filter of Periodic on my account and it solved the problem (e.g A#Account:V#Periodic).