Displaying Named Set????

#1

Hi,
I have created a named set 'TopCities' for the Sales cube in FoodMart. I
am not able to display the namedset in the cube or in FrontPage/OWC.
Following is the syntax for named set. Please help me to display this named
set. I am not sure what I am doing wrong

TopCount([Salesperson].[Salesperson Name].Members,10,[Measures].[Sales])

Thanks
Steve

#2

I posted the wrong syntax for named set. Syntax for named set 'TopCities' is

TopCount([Customers].[City].Members,10,[Measures].[Unit Sales])
--
Steve

"Steve" wrote:

Quote:

Hi,
I have created a named set 'TopCities' for the Sales cube in FoodMart. I
am not able to display the namedset in the cube or in FrontPage/OWC.
Following is the syntax for named set. Please help me to display this named
set. I am not sure what I am doing wrong

TopCount([Salesperson].[Salesperson Name].Members,10,[Measures].[Sales])

Thanks
Steve

#3

Don't you need to code in order to display named sets in excel or owc `?
"Steve" <Steve (AT) discussions (DOT) microsoft.com> wrote

Quote:

I posted the wrong syntax for named set. Syntax for named set 'TopCities'
is

TopCount([Customers].[City].Members,10,[Measures].[Unit Sales])
--
Steve

"Steve" wrote:

Hi,
I have created a named set 'TopCities' for the Sales cube in FoodMart.
I
am not able to display the namedset in the cube or in FrontPage/OWC.
Following is the syntax for named set. Please help me to display this
named
set. I am not sure what I am doing wrong

TopCount([Salesperson].[Salesperson Name].Members,10,[Measures].[Sales])

Thanks
Steve

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Displaying Named Set????

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

Displaying Named Set???? - 11-22-2005 , 03:57 PM

RE: Displaying Named Set???? - 11-22-2005 , 04:21 PM

Re: Displaying Named Set???? - 11-23-2005 , 04:22 AM