Hi,
I have two questions.
First on is like in the title. Is it possible to add, remove or modify a named set in an already deployed cube? I don't want to modify anything except the sets. If it is possible at all, are there any example of doing it?
Second is technical. I have redefined set "myRowsSet" to "myRowsSet2". What I did is I removed the calculated members and placed their code directly inside the set. Why isn't it working?
with -- road bikes in france member [Product].[Product Line].myMemberRoad as aggregate( existing( intersect( [Product].[Product Line].[Product Line].members ,[Product].[Product Line].&[R] -- road ) ) ) -- accessories in canada member [Product].[Product Line].myMemberAccessories as aggregate( existing( intersect( [Product].[Product Line].[Product Line].members ,[Product].[Product Line].&[S] -- accessory ) ) ) -- two members aggregated set myRowsSet as {myMemberRoad, myMemberAccessories} set myRowsSet2 as { aggregate( existing( intersect( [Product].[Product Line].[Product Line].members ,[Product].[Product Line].&[R] -- road ) ) ) ,aggregate( existing( intersect( [Product].[Product Line].[Product Line].members ,[Product].[Product Line].&[S] -- accessory ) ) ) } select {[Measures].[Internet Gross Profit]} on 0 ,NON EMPTY {myRowsSet, myRowsSet2, [Product].[Product Line].[All Products].children} on 1 from [Adventure Works]