Monthly Archives: February 2016

Parse SSRS Subscriptions Table

The Intransigent Data Blog Posted on by

Information about Report subscriptions is held in ReportServer.dbo.Subscriptions table. ExtensionSettings XML Fragment with root node <ParameterValues>  Contains information about the format and destination of the report. Each <ParameterValue> element has child <Name> and <Value> nodes : named according to classical … Continue reading →

Duration Dimension

The Intransigent Data Blog Posted on by

For measuring short durations, such as telephone calls or handling times. Q1 Linear Grain? The question I haven’t answered is whether the dimension should be at the finest grain for all durations.  The grain I am using is seconds but … Continue reading →