Search Results: percentile

• 
  referencing an ordered set iside a scope statement

  Hi, Has anyone actually created a calculated measure for percentile (or any kind of calculation that requires ordering a dimension based on a measure value in order to determine the value of a calculated measure ? (please note that I am not talking about

  Author:  fzfassoc     Date: 10/13/2011     Section: Forum

  tags : Calculated Members, percentile, Scope
• 
  Calculating Percentile in SQL Server Analysis Services MDX

  In this article, you'll learn how to use MDX to calculate percentile easily. See how to condense tons of T-SQL code to simple MDX calculations.

  Author:  BrianKnight     Date: 11/26/2009     Section: Article

  tags : calculations, percentile, mdx
• 
  Problem with RANK statement when used for a dynamic set inside SCOPE statement

  Hi, I am new to any complex or involved MDX code. I am stuck and I need to get this done. Would really appreciate your help. I am trying to create a calculated member for percentile and I found the approach in the following link http://www.bidn.com/articl

  Author:  fzfassoc     Date: 10/11/2011     Section: Forum

  tags : Calculations, percentile
• 
  Two more analytical functions: PERCENTILE_CONT and PERCENTILE_DISC

  I’ve been blogging a lot lately about the new analytic functions introduced with SQL Server 2012. I have two more to talk about: PERCENTILE_DISC and PERCENTILE_CONT. Previously, I covered CUME_DIST and PERCENT_RANK . Those two functions give you a p

  Author:  KathiKellenberger     Date: 12/11/2012     Section: Blog
• 
  Where do you rank? How to use PERCENT_RANK and CUME_DIST

  The last couple of years in the US have been marked by many discussions of numbers, to be more specific, percentages. It started with the 99% protests and, most recently, has included the unfortunate 47% comment by one of our presidential candidates. But,

  Author:  KathiKellenberger     Date: 10/23/2012     Section: Blog
• 
  Percentile value

  I've tried to comment on an article about percentiles by Brian Knight several times but just get a message saying that my comment will be posted after moderation and nothing ever actually posts. So I'll try here. Is there a way to produce the value for a

  Author:  amumaugh     Date: 9/13/2010     Section: Forum
• 
  T-SQL 2012 Features

  I've written a number of posts recently about the new T-SQL features. I thought it would be helpful for you to have a list with links to each one. You may also be interested in a Training on the T's webinar I did a couple of months ago where I demonstrate

  Author:  KathiKellenberger     Date: 12/18/2012     Section: Blog
• 
  Don't get left behind: Learn to use LAG

  Two of the most exciting developments in the T-SQL world are the enhancements to the OVER clause and the new analytic functions. These particular enhancements will enable us to write code to solve complex problems in a very efficient way. As they say in s

  Author:  KathiKellenberger     Date: 10/20/2012     Section: Blog
• 
  Calculated member for percentile in a cube

  Hi, i would like to create a caluclated member which should give me percentile for any given measure value. PLease can you reply asasp? Your help would be greatly appreaciated. Bhaskar

  Author:  Bhaskardasari     Date: 7/20/2010     Section: Forum
• 
  Calculated member for percentile in a cube

  Hi marco, please can you tell me how i can implement though it may take long time...i would try to implement.....all that i have to do is to create a measure for percentile

  Author:  Bhaskardasari     Date: 7/21/2010     Section: Forum
• 
  Long time saving report in excel format.

  I am new in SSRS. I created matrix report from Analysis Services db with rows containing category information and columns are names of clients. Data is a average sales. In a code part of the report I am collecting data in a sorted list and then calculatin

  Author:  Simona     Date: 7/27/2010     Section: Forum