Hi,

I need some help in making a named set.

I have a named set as below. It works fine.
TopCount([All Product Categories], 10)


I want to change it to:
TopCount([All Product Categories], 10, [Measures].[Sales])

Analysis Manager gives me an error - says - Formula Error - ("")
required entity missing.

Can anyone please point me to the right direction? What am I doing
wrong?
Would greatly appreciate it.
Thanks

You need a set in the topcount function, like
TopCount([Product].[Category].members, 10, [Measures].[Sales])
In your syntax I think you are pointing at a level and [All Product
Categories].members will help you if you have 10 members at that level.

HTH
Thomas Ivarsson
BI Consultant Malmö Sweden

"Harsh" <creative (AT) mailcity (DOT) com> wrote

[All Product Categories]
is actually a named set - [Product].[Category].members

OK. Replace [All Product Categories] with [Product].[Category].members or
try [Product].[All Product Categories] / {[Product].[All Product
Categories]}

HTH
/Thomas

"Harsh" <creative (AT) mailcity (DOT) com> wrote