Hi, I have one table which stores last updated date as one of the column. ETL job for this table is defined in such a way that when users updates or inserts any record in that table, last updated date will be updated for all rows(means there will be only one value for all records). Client wants this date to be shown in report as data last updated date in report. I created 1 Parameter based on that column and put in Text object but when new data is loaded date is not getting reflected. Date value remains same as it was there in the table when I created report. I am using SAS VA 8.3 on SAS Viya(V.03.04) platform. I know that I can add measures/ aggregated measures in text object but my date variable is in category list and I can't convert to measure not I can do any aggregation on it since it's in category list. What I've tried with parameter looks like this but new values are not reflecting===> Can someone guide me how to do this?
... View more