Hi All,

currently in my solution one cube structure has changed.

according to the new cube we are modifying the existing reports.

here my problem is

I prepared a dataset with new cube members

SELECT NON EMPTY { [Measures].[Scrapping BU],

[Measures].[Scrapping Local Currency],

[Measures].[Sales margin wo VAT (scrapping included)],

[Measures].[Stock sales wo VAT],

[Measures].[Sales margin wo VAT] } ON COLUMNS, NON EMPTY { (

[Product DIM].[Product Hierarchy FI].[MC0 FI].ALLMEMBERS ) }

DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT (

STRTOMEMBER(@FromBillingDateDIMDateHierarchyFI, CONSTRAINED) :

STRTOMEMBER(@ToBillingDateDIMDateHierarchyFI, CONSTRAINED) ) ON COLUMNS FROM ( SELECT (

STRTOSET(@MaterialSalesDIMAssortmentGrade, CONSTRAINED) ) ON COLUMNS FROM ( SELECT (

STRTOSET(@ProductDIMMCFI2, CONSTRAINED) ) ON COLUMNS FROM ( SELECT (

STRTOSET(@ProductDIMMCFI, CONSTRAINED) ) ON COLUMNS FROM ( SELECT (

STRTOSET(@StoreDIMStore, CONSTRAINED) ) ON COLUMNS FROM [Store Sales]))))) WHERE ( IIF(

STRTOSET(@StoreDIMStore, CONSTRAINED).Count = 1,

STRTOSET(@StoreDIMStore, CONSTRAINED), [Store DIM].[Store].currentmember ), IIF(

STRTOSET(@ProductDIMMCFI, CONSTRAINED).Count = 1,

STRTOSET(@ProductDIMMCFI, CONSTRAINED), [Product DIM].[MC4 FI].currentmember ), IIF(

STRTOSET(@ProductDIMMCFI2, CONSTRAINED).Count = 1,

STRTOSET(@ProductDIMMCFI2, CONSTRAINED), [Product DIM].[MC2 FI].currentmember ), IIF(

STRTOSET(@MaterialSalesDIMAssortmentGrade, CONSTRAINED).Count = 1,

STRTOSET(@MaterialSalesDIMAssortmentGrade, CONSTRAINED),

[Material Sales DIM].[Assortment Grade].currentmember ) )

CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING,

FONT_NAME, FONT_SIZE, FONT_FLAGS

this query running well in query designer.

but after previewing am getting the following error.

ERROR::crying: Query (12,69) The Restrictions imposed by the constrained flag in the strtoset function were voilated""""

I already gone through some posts:

I have discovered that I needed to make adjustments to the Dimension definitions to not allow unknown as an option. Once I made the change and rebuilt the cubes, the report no longer threw the Constraint error.

but in my case : am just creating a copy of old report and applying changes as per the TEST cube .

in my previous cube also , unknown member is present.

but am not getting any error there.

can anybody please siggest something on this.

my all new reports are showing same error.

Thanks in advance

Niha