Hello,
I learned that named sets are good when you need to define some additional, non-standart dimensions using functions like topcount etc. But in witch client can I use them? As I undrestand, I cannot use them into excel 2000 and AS manager?

Ramunas

The OWC pivot control lets you specify an MDX SELECT statement, which in turn can reference a named set.

Some clients expose named sets in UI though I can't provide a definitive list. Panorama and Proclarity are likely candidates.

public @ the domain below
www.tomchester.net


"ramblk" <ramblk1 (AT) hotmail (DOT) com> wrote

Hello,
I learned that named sets are good when you need to define some additional, non-standart dimensions using functions like topcount etc. But in witch client can I use them? As I undrestand, I cannot use them into excel 2000 and AS manager?

Ramunas

Another Analysis Services client which can use Named Sets (eg: for Time
Series) is DSP Portal Edition 4.0:

http://www.dspanel.com/files/Technic..._DSP_PE_40.pdf


- Deepak

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!