Can i get date based on whenever the report is refreshed?

[Former Member]

Hi All,

I have three Columns in my report. it looks like this

Member      Amount      Type

0123               500          Non-Preferred Member

0123               450          Preferred Member

Here Preferred and Non-Preferred Type depends on the object "TYPE" which is being used in the Universe to get this Preferred and Non-Preferred.

This TYPE object always keep on changing (refreshing in backend).  So i want to show Member based on Most recent or at whatever time i refresh my report it should give the recent data.

Any suggestions on how to do this???

Thank You

[former_member184594]

What is your reporting database? Do you have recent date values for TYPE object in the database? If you don't, I am afraid you may not achieve this.