|
|
|
Forum Newbie
Group: General Forum Members
Last Login: 2 days ago @ 6:40 AM
Points: 1,
Visits: 52
|
|
Hi
I have tried to create dynamic named sets in SSAS 2008 standard edition, for example:
TOPCOUNT([Product].[Product Name].[Product Name].MEMBERS, 5, [Measures].[Sales Amount] )
Type: Dynamic
Query returns top 5 products, but if I change filters (year etc), the original result set will not be recalculated and the query returns 0-5 results from the original result set depending on filters I use. I thought that in dynamic sets the result set will always be recalculated if filters change and in this case new top 5 products will be returned.
Is there something wrong in my dynamic set? Could someone help?
Lauri
|
|
|
|
