InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 01:42:19 GMT20http://www.sqlservercentral.com/Forums/Topic1423289-147-1.aspxI have 3 dimension tables - team, gamedate and gameinfo. A fact table that has teamid,gamedateid. A bridge table that has gamedateid,gameinfoid. I created 2 measure groups one on fact table and one on bridge table and set up many to many dimension usage in the cube. I am trying to derive the following using calculated members and having trouble as I am new to mdx.1)Count number of other games that happened between game1 and the following game1.I am using following query - getting the first and last date for game1 using head and tail functions and getting other gamecount but getting error:The : function expects a member expression for the 1 argument. A tuple set expression was used.select[Measures].[gamecount]from [game]where(head(filter([date].[YearQMD].[Date],[gameinfo].[gameinfo].&[game1])):tail(filter([date].[YearQMD].[Date],[gameinfo].[gameinfo].&[game1])))Fri, 22 Feb 2013 16:28:19 GMTdivyaduttadddy