Who is online?
0
guests and
1
members
Member login
|
Become a member
Home
Articles
Forums
Blogs
Jobs
Events
Files
Spaces
People
login
register
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
Date: 10/13/2011 Section:
Forum
tags :
Calculated Members
,
percentile
,
Scope
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
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
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
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
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
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
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
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
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
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
Page 1 of 1 (13 items)