reloading front end values back into script without using macro/variable
Hi All,
I have a number of metrics which i calculate at the front end. many require set analysis expressions, and /or certain selections.
What i would like to do is load a table in the script which would record these values, and export them to a qvd which would be timestamped. Then this would be loaded back into the dashboard , along with the timestamp so we could view historic trending. basically, we would have a row for each time the data was refreshed, i.e. each new timestamp.
Previous attempts have included a macro which exports the underlying table and it's associated values. Due to the server our files reside on this is not an option.
Futhermore i have modelled a table using many joins etc to get some of the figures but I'm just wondering if there is a better way.
Does anyone know of a way in which we can reference front end expressions (which would be variables) which would be a specific value and load this into a table. Previous attampts at this have simply loaded the expression contained in the variable (i.e. the expression syntax) but no actual numeric values which is the requirement.
Any thoughts/suggestions would be much appreciated.
