|
Home > Archive > MS SQL Server OLAP > November 2005 > Displaying Named Set????
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Displaying Named Set????
|
|
|
| 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
| |
|
| 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
| |
| michael v 2005-11-23, 7:24 am |
| Don't you need to code in order to display named sets in excel or owc `?
"Steve" <Steve@discussions.microsoft.com> wrote in message
news:7E3197A0-3D29-4528-9792- D20E045FEAA9@microso
ft.com...
> I posted the wrong syntax for named set. Syntax for named set 'TopCities'
is[color=darkred]
>
> TopCount([Customers].[City].Members,10,[Measures].[Unit Sales])
> --
> Steve
>
>
> "Steve" wrote:
>
I[color=darkred]
named[color=darkred]
|
|
|
|
|