I am new to MDX and Analysis Services. I have a simple report written with Visual Studio 2005's Reporting Services (v 8.0.50727.762) that reads data off of an Analysis Services cube.
I have 1 parameter so that the report is filtered by a Valuation Time (from the Valuation Time Dimension). Each day there is new data for the new Valuation Time.
I want to schedule this report to run automatically so that this parameter has either the latest Valuation Time from the Valuation Time Dimension selected, OR, just have the truncated system date show up (MM, DD, and YYYY). I'd be happy with either solution.
This report is hosted on a Report Manager reporting server. Also note that our Valuation Time Dimension is also a String and not set up as Date Time (don't ask, lol).
Anyone know how I can setup the Default Value of this parameter? I have the parameter set up as Available Values: From Query, and Default Values, Non Queried.
When I hardcode the default parameter I get the result I want, but this needs to be more dynamic:
[DIM Valuation Time].[Valuation Time].&[2009-03-17T00:00:00]