BookmarkSubscribeRSS Feed
hilal1422
Fluorite | Level 6

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===>

 

image.png

 

 

Can someone guide me how to do this?

 

 

4 REPLIES 4
jblack38
Obsidian | Level 7
I have the same issue. I have not found any articles that describe how to do this. It seems like SAS should allow you to display whatever data fields you want (categories or measures) in a Text object.
This seems to be a serious design flaw with SAS reports.
johnfrytz
Obsidian | Level 7
There is a refresh option, I encountered it before. It basically recalculate the object. Try the "automatically refresh object".
If not, look for the refresh option on the object which the parameter it sourced. Apologies, I forgot which test VA report I was able to the same thing.
acordes
Rhodochrosite | Level 12
You can convert date stored as character into numeric (date) by using the PARSE operator under create new data item.
You must tell VA how to interpret the date format stored as string. Perhaps you need to combine with the substr operator or the datetime operator.
This should work for treating the date as numeric.
Independently of having the date as character or numeric you should be able to use it in a text object. Create a new data item using the concatenate function with the suffix and prefix for the last update date.
Use this item in text object.
betmath
SAS Employee

This is an old post, so maybe already solved. But here is another possible resolution for future people searching.

I also use a parameter to add a data refresh date to a text box. I load my data to CAS with a refresh date character column formatted how I want it to display in VA. Then, in VA I create a required user prompt based on this refresh date data item (only contains one unique value). I assume this is what hilal1422 did as well in the original post to get the date parameter, or something similar. 

At first, I hid my required ("mock") user prompt on a hidden page in the report. I also set the user prompt to update every 1 seconds. When I did this I experienced the prompt and parameter combo not updating automatically when new data was pushed to CAS. I opened this support track (7613487958 - https://sirius.na.sas.com/Sirius/ShowTrack.aspx?trknum=7613487958).  

I followed that advice of doubling up on the user prompt so that the "Initially select first item" checkbox would appear in the options. That may work long term and certainly seemed to work better, but I have still experienced times when the prompt parameter combo seemed to not update. 

What I have sense done (thanks to a advice from a fellow VA user), and what I believe will work better and 100% of the time, is move the required user prompt to the same page as the text box parameter and hiding it in a precision container behind another object. I think this may be the key to solving my issue, and possibly the original issue of this ticket. Again, the user prompt the parameter is based on must be hidden on the SAME page as the text object the parameter is used in. 

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

Register now!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 4 replies
  • 1144 views
  • 1 like
  • 5 in conversation