Search Results: LastPeriods

• 
  MDX Named Set Rolling Date Range

  In an Analysis Services Cube (SSAS), named sets can be used to filter data. One of the popular request I get for named sets are rolling date ranges. Here are some examples of rolling date range named sets I have created. There are several ways to make thi

  Author:  MikeDavis     Date: 4/5/2011     Section: Blog

  tags : Named Sets, Range, Rolling Date, MDx
• 
  LastPeriods and PeriodstoDate

  There are several ways for calculating “To-Date” calculations the longer way. These normally include a more granular level of control and less reliance on default options. The two functions in this post are examples of that added control and functionality

  Author:  AdamJorgensen     Date: 2/20/2010     Section: Blog

  tags : LastPeriods, MDX, PeriodsToDate
• 
  Finding rolling costs for 13 months

  Hi Experts, I need urgent help on this issue I have a formula 'Sum(LastPEriods(13, CLosingPeriod([Rolling Date].[Month], [Rolling Date].CurrentMember)), [Measures].[Waste Costs])' which calculates rolling costs for last 13 months e.g today current month +

  Author:  qutesanju     Date: 9/6/2010     Section: Forum

  tags : analysis services, MDX, rolling costs
• 
  MDX equivalent to T-SQL UNION

  Hi. The following MDX query returns what I want for a single KPI. WITH MEMBER [KPI Name] AS "Some KPI" MEMBER [KPI Value] As KPIValue("Some KPI") MEMBER [KPI Status] AS KPIStatus("Some KPI") MEMBER [KPI Trend] As KPITrend("Some KPI") SELECT { [KPI Name],

  Author:  JustinJohnson     Date: 1/20/2011     Section: Forum

  tags : KPIs, MDX, union
• 
  MDX and Parameters??

  Here is what my current query looks like. I am using the [Current Teams] in a subselect because since it is dynamic I have SSRS can't doesn't allow me to use the dimension value in my chart because there is no metadata. The reason I am using date in a sub

  Author:  skerr     Date: 5/23/2012     Section: Forum
• 
  Median with a time filter

  Randi, Not sure if you are looking for the average median of the GP over the last six months or what you actual are looking for but you could do sometrhing like avg({ LastPeriods (6,[Dim Time].[YQMD].[TIME MTH].&[2012]&[2])}, Median([Dim Location]

  Author:  snake9284     Date: 5/25/2012     Section: Forum