I have a number of sdml's within my SSRS solution. On occasion, the view behind the .dsv changes. Most of these changes are based on
decimal therefore users require the
total, avg, min and max agrregates.
When you 1st create a model all these fancy features are auto-generated (which in most cases is fine), but when adding addition field to the model I am unable fine this option (tried running the "autogenerate" function again to no avail).
There anyway to auto generate these aggregates after the sdml has been created?
Answer by sp_lock ·
I sorted this...
Was my muppetry!!!
This creates the new fields with the aggregates.
What I was doing was adding the top level fiels (binded to the dsv) and then trying to autogenterate! Doing this way doesnt generate the aggregates after the field is added.