Difference between Comma and Asterisk

Question

question

Raj More asked Nov 13, '09

Difference between Comma and Asterisk

Can someone please explain to me the difference between the following queries

SELECT
    NON EMPTY {([Measures].[MeasureName])} ON COLUMNS,
    NON EMPTY
    {(
    	[Dimension01].[ColumnName01].AllMembers
    	* [Dimension02].[ColumnName03].AllMembers
    	* [Time Period].[WeekStartDate].AllMembers
    )} 
    DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS
FROM [CubeName]

and now using commas

SELECT
    NON EMPTY {([Measures].[MeasureName])} ON COLUMNS,
    NON EMPTY
    {(
    	[Dimension01].[ColumnName01].AllMembers,
    	[Dimension02].[ColumnName03].AllMembers,
    	[Time Period].[WeekStartDate].AllMembers
    )} 
    DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS
FROM [CubeName]

ssas mdx

2

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Gustavo commented · Nov 18, 2009 at 08:03 AM

When you run these queries against your environment what where the results on both cases ? Does they return the same resultset ?

0 ·

Raj More commented · Nov 18, 2009 at 01:55 PM

Yes they return the same resultset.

0 ·

Answer 1 · 2009-11-16T11:28:31Z

Jack Corbett answered Nov 16, '09

I really don't know anything about MDX, but I'm gonna venture a guess that the asterisk is the multiplication operator and the comma defines 3 different columns. Again, just a guess although BOL does state that the asterisk is the multiplication operator.

2

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Raj More commented · Nov 18, 2009 at 01:55 PM

can you post a link to the BOL topic

0 ·

Jack Corbett commented · Nov 19, 2009 at 11:15 AM

Here are some links that apply to the asterisk: http://msdn.microsoft.com/en-us/library/ms144816.aspx http://msdn.microsoft.com/en-us/library/ms132003.aspx http://msdn.microsoft.com/en-us/library/ms132189.aspx

0 ·

question