For those of you who have missed it. I started a new MDX 101 blog at http://101mdx.blogspot.com.
Have Fun And Till Next Time
Tuesday, July 29, 2014
Sunday, November 3, 2013
Age at January first each year
CREATE MEMBER CURRENTCUBE.[Measures].[Age jan1]
AS Datediff("yyyy",[Customer].[Birth Date].CurrentMember.Name, CDATE("01/01/"+ right([Date].[Calendar Year].CurrentMember.Member_value,4))),
VISIBLE = 1, DISPLAY_FOLDER = 'Ages' ;
Till Next Time
AS Datediff("yyyy",[Customer].[Birth Date].CurrentMember.Name, CDATE("01/01/"+ right([Date].[Calendar Year].CurrentMember.Member_value,4))),
VISIBLE = 1, DISPLAY_FOLDER = 'Ages' ;
Till Next Time
SSAS Ages at current date
CREATE MEMBER CURRENTCUBE.[Measures].[Age Years]
AS Datediff("yyyy",[Customer].[Birth Date].CurrentMember.Name, NOW()),
VISIBLE = 1, DISPLAY_FOLDER = 'Ages' ;
CREATE MEMBER CURRENTCUBE.[Measures].[Age Months]
AS Datediff("M",[Customer].[Birth Date].CurrentMember.Name, NOW()),
VISIBLE = 1 , DISPLAY_FOLDER = 'Ages' ;
CREATE MEMBER CURRENTCUBE.[Measures].[Age Months To Years]
AS Datediff("M",[Customer].[Birth Date].CurrentMember.Name, NOW())/12,
FORMAT_STRING = "#.##0,0",
VISIBLE = 1 , DISPLAY_FOLDER = 'Ages' ;
CREATE MEMBER CURRENTCUBE.[Measures].[Age Days]
AS Datediff("d",[Customer].[Birth Date].CurrentMember.Name, NOW()),
VISIBLE = 1, DISPLAY_FOLDER = 'Ages' ;
Till Next Time
AS Datediff("yyyy",[Customer].[Birth Date].CurrentMember.Name, NOW()),
VISIBLE = 1, DISPLAY_FOLDER = 'Ages' ;
CREATE MEMBER CURRENTCUBE.[Measures].[Age Months]
AS Datediff("M",[Customer].[Birth Date].CurrentMember.Name, NOW()),
VISIBLE = 1 , DISPLAY_FOLDER = 'Ages' ;
CREATE MEMBER CURRENTCUBE.[Measures].[Age Months To Years]
AS Datediff("M",[Customer].[Birth Date].CurrentMember.Name, NOW())/12,
FORMAT_STRING = "#.##0,0",
VISIBLE = 1 , DISPLAY_FOLDER = 'Ages' ;
CREATE MEMBER CURRENTCUBE.[Measures].[Age Days]
AS Datediff("d",[Customer].[Birth Date].CurrentMember.Name, NOW()),
VISIBLE = 1, DISPLAY_FOLDER = 'Ages' ;
Till Next Time
Sunday, February 3, 2008
Welcome tot SSAS101
Hi, My name is John Minkjan and I'm a senior BI-consultant at i8Solutions in the Netherlands. I reserverd a couple of ...101 blogspots. At the moment I'm mostly active on OBIEE101. I will start posting here as soon as my focus in back on Microsoft Sequel Server Analytic Services.
Till Next Time
John
Till Next Time
John
Subscribe to:
Posts (Atom)