September 11, 2008 at 2:53 pm
I've been struggling trying to get this report up for three days now.
The report is from an SSAS source.
There are 4 parameters. Two for a date range, and tow others that are strings.
If I just leave all the parameters as strings, the report is usable. However I wanted to use the Calender control. I set up the date range parameters to use calender controls, but now the report errors out as soon as it has to work with the other parameters.
Both Date parameters have had the Parameter Value changed in the dataset tab
="[Dim Date Order].[Date MMDDYYYY].&[" + Format(CDate(Parameters!FromDimDateOrderDateMMDDYYYY.Value), "s") + "]"
="[Dim Date Order].[Date MMDDYYYY].&[" + Format(CDate(Parameters!ToDimDateOrderDateMMDDYYYY.Value), "s") + "]"
The other parameters have not been changed at all (in either the DataSet or the Report Parameters windows. They are named DimLocationOrderLocationName, and DIMRouteMasterOrderRouteRouteName. They are both multi-valued, string parameters.
I can create a report with JUST the date range as well with the calender controls and it'll run fine, it's when I add another parameter is will stop working.
I get the following error if I set the defaults of the TO date=today
and the FROM date =DateAdd("d", +10, today)
"An error occurred during local report processing.
An error has occurred during report processing.
Query execution failed for data set 'DimLocationOrderLocationName'.
Parser: The syntax for '7' is incorrect
However, if I set the defaults to "Null" I can pick dates, but will get THIS error after both dates are picked:
"An error occurred during local report processing.
An error has occurred during report processing.
Query execution failed for data set 'DimLocationOrderLocationName'.
Query (1, 503) The restrictions imposed by the CONSTRAINED flag in the STRTOMEMBER function were violated.
Full MDX query of the report is as follows: SELECT NON EMPTY { [Measures].[Perm Units], [Measures].[Temp Units] } ON COLUMNS, NON EMPTY { ([DIM Route Master Order].[Route # - Route Name].[Route # - Route Name].ALLMEMBERS * [DIM Customer Master Order].[Customer # - Customer Description].[Customer # - Customer Description].ALLMEMBERS * [DIM Product Master Order].[Product # - Product Description].[Product # - Product Description].ALLMEMBERS * [Dim Date Order].[Friendly Date].[Friendly Date].ALLMEMBERS * [Dim Date Order].[Date].[Date].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( STRTOSET(@DIMRouteMasterOrderRouteRouteName, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@DimLocationOrderLocationName, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOMEMBER(@FromDimDateOrderDateMMDDYYYY, CONSTRAINED) : STRTOMEMBER(@ToDimDateOrderDateMMDDYYYY, CONSTRAINED) ) ON COLUMNS FROM [SALES OLAP ORDER]))) WHERE ( IIF( STRTOSET(@DimLocationOrderLocationName, CONSTRAINED).Count = 1, STRTOSET(@DimLocationOrderLocationName, CONSTRAINED), [Dim Location Order].[Location Name].currentmember ) ) CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS
Any help on this would be GREATLY appreciated.
Thanks for your time
September 11, 2008 at 5:44 pm
Apparently changing the order (doing the string parameters before the dates) was enough to fix the problem. Still not sure why the report wasn't working in the first place. At least it works now.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply