Who is online?  0 guests and 0 members
Home  »  search results

Search Results: ParallelPeriod

16 results found
  • SSAS MDX Previous Year to Date
    Getting the YTD from a cube is a simple MDX formula either using the PeriodToDate function or using the YTD function. One request you may get it to see the previous year to date. So if you are looking at March 21, 2011 year to date, you want to see the ye
    Author: MikeDavis MikeDavis     Date: 6/23/2011     Section: Blog
  • Leap Year issue with MDX date navigation
    A few days ago (exactly one day after 29th of February when testing data from last night's load) I experienced a strange issue which I couldn't explain at first but then found out that it is related to the leap year and to the fact that even though this y
    Author: MartinIsti MartinIsti     Date: 3/2/2012     Section: Blog
  • Last Year sales problem
    I am new to SSAS with no training and no support. A consulting firm helped us with the MDX, but that's that. Our calendar year works from July to June, but not the 1st. Last year 27/06/2010 to 25/06/2011 and current year from 26/06/2011 till 30/06/2012. T
    Author: Helcas Helcas     Date: 1/16/2012     Section: Forum
  • marking first occurrences (mdx)
    Hi all, I am still pretty new to mdx and I got the following problem: Our Sales department wants a report which covers: Sales for last month Sales accumulated (the same for 2010 and 2009) For last month, they want to see how many new customers we created
    Author: r_eggenberger r_eggenberger     Date: 1/20/2011     Section: Forum
  • MDX Utility Belt of Calculations Part 4
    This is part four in the series of blog posts that will help in building a library of calculations you can use as a reference in any analysis services cube you build. You can find the previous posts to this blog series below: Part 1 – ParallelPeriod Part
    Author: DevinKnight DevinKnight     Date: 12/7/2009     Section: Blog
    tags : MDX
  • SSAS Calculation to Pull Previous Month Last Day
    Hi, I think you are going to need to define an attribute in your date dimention that defines MONTH END dates. We do this in our application and then run reports based on these Month End dates. Below is an example of our TREND EXPRESSION for one of our KPI
    Author: bretupdegraff bretupdegraff     Date: 12/1/2009     Section: Forum
  • SSAS Calculation to Pull Previous Month Last Day
    Thank you for your reply. If I could create a attribute that would be just month end dates that would definately help. Just curious, where do you do the Month End attribute? Is it as a named calculation? Another option is that I believe I can have the KPI
    Author: EGAN EGAN     Date: 12/2/2009     Section: Forum
  • mdx cube calculation that may need to use some type of subquery
    Hi Dustin, Well I have something now happening using the following code CREATE MEMBER CURRENTCUBE.[Measures].[LY_Fix_Act] AS NULL, FORMAT_STRING = "#,#0;(#,#0)", VISIBLE = 1; CREATE MEMBER CURRENTCUBE.[Measures].[SumMeasure] AS [Measures].[Actual], VISIBL
    Author: robbie robbie     Date: 7/22/2010     Section: Forum
  • mdx cube calculation that may need to use some type of subquery
    Hi Justin, LY_Act is my original function and works fine when showing data at the period level. So this means that it will only show data for LY_Act if the pub was with the BDM during that time period. For some reason it does NOT show a value when rolled
    Author: robbie robbie     Date: 7/23/2010     Section: Forum
  • MDX Utility Belt of Calculations Part 2
    This post is a part of a series of blog posts I am writing to give you a Batman-like Utility Belt of MDX calculations. With this Utility Belt available you can have a template of commonly needed calculations you can use for just about any Analysis Service
    Author: DevinKnight DevinKnight     Date: 12/1/2009     Section: Blog
  • MDX Puzzles: The Fifth Element - Answer
    Our latest MDX puzzle called for using a few functions we haven't used yet. To solve the Fifth Element puzzle, we were required to show the Year to Date Reseller Sales, the Reseller Sales for the same month in the previous year, and the Reseller Sales Amo
    Author: DustinRyan DustinRyan     Date: 12/10/2010     Section: Blog
  • calculation - not sure what to do
    With Member PRE as ([Measures].[Internet Sales Amount],parallelperiod([Date].[Calendar].[Calendar Year],1)),format_string="currency" select {[Measures].[Internet Sales Amount],pre} on 0,[Date].[Calendar].[Calendar Year].&[2007] on 1 from [Adventure Wo
    Author: gurucb gurucb     Date: 9/2/2011     Section: Forum
  • Period to Period growth in Report
    Here is my MDX statement: When [ZEIT MONAT].[Jahreskalender].CurrentMember.Level Is [ZEIT MONAT].[Jahreskalender].[(All)] Then "NA" When IsEmpty ( ( ParallelPeriod ( [[ZEIT MONAT].[Jahreskalender].[JAHR], 1, [ZEIT MONAT].[Jahreskalender].CurrentMember ),
    Author: Krissi87 Krissi87     Date: 5/3/2012     Section: Forum
  • Combining Aggregate function and STRTOSET function in Dynamic query
    STRTOSET(@DiallerCampaignDetailsCallDirection, CONSTRAINED), [Dialler Campaign Details].[Call Direction].currentmember ), ="WITH " & "MEMBER [Measures].[Selected Measure] AS [Measures].[" & Parameters!MeasureName.Value & "] " & "MEMBER [Me
    Author: CarlThompson CarlThompson     Date: 8/13/2012     Section: Forum
  • mdx cube calculation that may need to use some type of subquery
    Here's an example of an MDX script that should help you get started: CREATE MEMBER CURRENTCUBE.[Measures].[Act] AS NULL, VISIBLE = 1; CREATE MEMBER CURRENTCUBE.[Measures].[SumMeasure] AS SUM(calculatewhatever here), VISIBLE = 1; SCOPE ([Measures].[Act]);
    Author: DustinRyan DustinRyan     Date: 7/20/2010     Section: Forum
  • mdx cube calculation that may need to use some type of subquery
    Please ignore the javasript bits - newbie to using the insert code widget on the site CREATE MEMBER CURRENTCUBE.[Measures].[LY_Fix_Act] AS NULL, VISIBLE = 1; CREATE MEMBER CURRENTCUBE.[Measures].[SumMeasure] AS [Measures].[Actual], VISIBLE = 1; SCOPE ([Me
    Author: robbie robbie     Date: 7/21/2010     Section: Forum
Page 1 of 1 (16 items)