07-10-2024 08:57 AM - edited 07-10-2024 11:17 AM
Does anyone know the BR to change the date format of the Cube view Report footer from ("MM/dd/yyyy h:mm:ss tt") to ("dd/MM/yyyy h:mm:ss tt") via Business Rule Cube view extender?
Is there also a rule to show the Username on the Report footer? Would be ideal to show it in the center of the report footer.
Thanks
Solved! Go to Solution.
07-10-2024 03:54 PM
For the user name, you can use the sub var |UserName| in the report footer like this:
This will come out on the PDF report.
For the date format still researching.
07-10-2024 03:54 PM
For the user name, you can use the sub var |UserName| in the report footer like this:
This will come out on the PDF report.
For the date format still researching.
07-10-2024 04:09 PM - edited 07-10-2024 04:11 PM
There is an enhancement request to have this date footer on reports work off the user's culture code. It is in Idea Stream here: (2) JIRA Ticket: PF-4353 (onestreamsoftware.com)
But if you search in One Community you can find an example here: How to get Date, Time and Time Zone in Report Footer using Cube View Extender Rule. - OneStream Comm...
07-11-2024 07:30 AM
The second solution didn't work in the Cube view Extender Rule.
I need the complete Business Rules, which is used within the CV Extender Inline Formula and starts with:
Select Case args.FunctionType
Case Is = CVExtenderFunctionType.FormatReportUIItem
Dim uiItem As CVExtenderReportUIItem = args.Report.CurrentUIItem
If uiItem.UIItemType = XFReportUIItemType.PageFooterDate Then....
Thanks