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

Search Results: percentile

13 results found
  • 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 fzfassoc     Date: 10/13/2011     Section: Forum
  • 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 fzfassoc     Date: 10/11/2011     Section: Forum
  • 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 BrianKnight     Date: 11/26/2009     Section: Article
  • 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 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 KathiKellenberger     Date: 10/23/2012     Section: Blog
  • 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 KathiKellenberger     Date: 12/18/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 amumaugh     Date: 9/13/2010     Section: Forum
  • Calculated member for percentile in a cube
    percentile is some of the hardest things in BI that I've experienced... To have that information in a cube, I advice you to agregate all possible combinations from all dimensions, to a table. Wich is quite heavy... But if you want that information asap, I
    Author: marcoadf marcoadf     Date: 7/20/2010     Section: Forum
    tags : percentile
  • Calculated member for percentile in a cube
    Check out this article. Looks like it's missing the screen shots but should help. http://www.bidn.com/articles/mdx-and-dmx/6/calculating-percentile-in-sql-server-analysis-services-mdx
    Author: DevinKnight DevinKnight     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 Simona     Date: 7/27/2010     Section: Forum
  • 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 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 Bhaskardasari     Date: 7/21/2010     Section: Forum
  • 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 KathiKellenberger     Date: 10/20/2012     Section: Blog
Page 1 of 1 (13 items)