September 30, 2010 at 2:35 am
Hello Experts,
I have created a SSRS report that show unit solds and sales quantity. At first, one of parameters named Warehouses has no hierarchy. But when I design a hierarch on this dimension (in SSAS) then I get an error message.
I have attached a screenshot that shows this error.
[p]
WITH
MEMBER Measures.[Stock Level] AS SUM([Dim Date].[WeeklyCalendar].[Week Of Year].members(0):ClosingPeriod([Dim Date].[WeeklyCalendar].[Week Of Year]), Measures.[Quantity] )
SELECT NON EMPTY { [Measures].[Quantity], [Measures].[Sale Unit],[Measures].[Stock Level] } ON COLUMNS,
NON EMPTY { ([Dim Product MAX].[Style Code].[Style Code].ALLMEMBERS ) }
DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM
( SELECT ( STRTOSET(@DimDateWeeklyCalendar, CONSTRAINED) ) ON COLUMNS FROM
( SELECT ( STRTOSET(@DimWarehousesMAXWarehouses, CONSTRAINED) ) ON COLUMNS FROM [HC_WEEKLYSALES]))
WHERE ( IIF( STRTOSET(@DimWarehousesMAXWarehouses, CONSTRAINED).Count = 1, STRTOSET(@DimWarehousesMAXWarehouses, CONSTRAINED), [Dim Warehouses MAX].[Warehouses].currentmember ), IIF( STRTOSET(@DimDateWeeklyCalendar, CONSTRAINED).Count = 1, STRTOSET(@DimDateWeeklyCalendar, CONSTRAINED), [Dim Date].[WeeklyCalendar].currentmember ) )
CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS
[/p]
If I remove the Warehouse hierarchy on SSAS everything goes well.
What can I do? Please help
October 2, 2010 at 4:45 am
The CONSTRAINED flag requires the selected member name to be resolved to a qualified member name. Drop a textbox on your report and set it to expression:
=Join(Parameters!<parameter name>.Value,", ")
Run the report. Does the output looks like valid member names?
BI Developer
SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
Please visit... ApplyBI
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply