Sets in SQL 2005

#1

How do we tell if a set has been created for a dimension other than by going
into the "Calcuations" tab in the Cube Designer?

#2

In article <#Lf4PPpbGHA.4932 (AT) TK2MSFTNGP03 (DOT) phx.gbl>, Jonty (AT) Jonty (DOT) com
says...

Quote:

How do we tell if a set has been created for a dimension other than by going
into the "Calcuations" tab in the Cube Designer?

You can use MDSCHEMA_SETS schema rowset to find out what sets have been

defined. Although you should note that sets are not created "for a
dimension".

From Books online for AS 2000:

Quote:

The tuple uniquely identifies a section in the cube; it does not have to

refer to a specific cell, nor does it have to encompass all of the
dimensions in a cube.

....

An ordered collection of tuples is referred to as a set. In an MDX
query, axis and slicer dimensions are composed of such sets of tuples.

Quote:

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

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

Sets in SQL 2005

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

Sets in SQL 2005 - 05-03-2006 , 04:33 AM

Re: Sets in SQL 2005 - 05-03-2006 , 07:40 AM