I am using SQL 2005 AS and I have an olap cube with the "total costing" as
one of the "measure" and one diamension consisting with several attributes,
"account period", "product", "fiscal year" ... etc. I need to create a "Top
10 highest Cost Product" from this cube. As a result end-user can select any
"account period" or "fiscal year" and to find out the top 10 product cost.

Under the "Calculations" tab I created a new "named set" and called it "Top
10 Product Cost" and assigned the expression as follows:

TOPCOUNT([Pharmacy DW By Account Period].[Product].[Product],10,[Measures].
[Total Cost] )

Under the "Browser" tab I browsed the data on the cube and applied this new
named set to it, the result set does not match the number of records and some
of the records does not show up as to the result querying directly from the
table. Thanks

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...-olap/200608/1

The name set is not dynamic, it will always return the top 10 for all
periods. To achieve the dynamic nature, you need to dynamically define the
set within your MDX statement. For example

TOPCOUNT([Pharmacy DW By Account Period].[Product].[Product],10,([Measures].
[Total Cost], [fiscal year].currentmember )


"pmak via SQLMonster.com" wrote: