SSAS: distribution of measures over percentage

Posted by Alex on Stack Overflow See other posts from Stack Overflow or by Alex
Published on 2010-03-09T17:05:40Z Indexed on 2010/03/13 5:45 UTC
Read the original article Hit count: 709

Filed under:

ssas

|

cube

|

sql-server

|

olap

Hi there,

I am running a SSAS cube that stores facts of HTTP requests. The is a column "Time Taken" that stores the milliseconds a particular HTTP request took.

Like...

RequestID     Time Taken
--------------------------
1             0
2             10
3             20
4             20
5             2000

I want to provide a report through Excel that shows the distribution of those timings by percentage of requests. A statement like "90% of all requests took less than 20millisecond".

Analysis:

100%          <2000
80%           <20
60%           <20
40%           <10
20%           <=0

I am pretty much lost what would be the right approach to design aggregations, calculations etc. to offer this analysis through Excel.

Any ideas?

Thanks, Alex

© Stack Overflow or respective owner

Related posts about ssas

SSAS Maestro Training in July 2012 #ssasmaestro #ssas

as seen on SQL Blog - Search for 'SQL Blog'
A few hours ago Chris Webb blogged about SSAS Maestro and I’d like to propagate the news, adding also some background info. SSAS Maestro is the premier certification on Analysis Services that selects the best experts in Analysis Services around the world. In 2011 Microsoft organized two rounds of… >>> More
SSAS – Synchronisation performance

as seen on SQL Blogcasts - Search for 'SQL Blogcasts'
I’ve always thought of SSAS synchronisation as a clever file mirroring utility built into SSAS and i have never considered the technology as bringing any performance gains to the table. So, its a good job I like to revisit areas…. :) I decided to compare the performance of robocopy and SSAS Synchronisation… >>> More
Query Logging in Analysis Services

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
On a project I work on, we capture the queries that get executed on our Analysis Services instance (SQL Server 2008 R2) and use the table for helping us to build aggregations and also we aggregate the query log daily into a data warehouse of operational data so we can track usage of our Analysis databases… >>> More
SSAS: distribution of measures over percentage

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi there, I am running a SSAS cube that stores facts of HTTP requests. The is a column "Time Taken" that stores the milliseconds a particular HTTP request took. Like... RequestID Time Taken -------------------------- 1 0 2 10 3 20 4 20 5 … >>> More
Preserving Language across inline Calculated Members in SSAS

as seen on Stack Overflow - Search for 'Stack Overflow'
Problem: I need to retrieve the language of a given cell from the cube. The cell is defined by code-generated MDX, which can have an arbitrary level of indirection as far as calculated members and sets go (defined in the WITH clause). SSAS appears to ignore the Language of the specified members when… >>> More

Related posts about cube

Morph a sphere to a cube and a cube to a sphere with GLSL

as seen on Game Development - Search for 'Game Development'
I'm getting started with GLSL with quartz composer. I have a patch with a particle system in which each particle is mapped into a sphere with a blend value. With blend=0 particles are in random positions, blend=1 particles are in the sphere. The code is here: vec3 sphere(vec2 domain) { vec3 range; … >>> More
morph a sphere to a cube and a a cube to a sphere with GLSL

as seen on Game Development - Search for 'Game Development'
hi i'm getting started with glsl with quartz composer. i have a patch with a particle system in which each particle is mapped into a sphere with a blend value. with blend=0 particles are in random positions, blend=1 particles are in the sphere. the code is here: vec3 sphere(vec2 domain) { … >>> More
Win32 strange exception

as seen on Game Development - Search for 'Game Development'
When creating 2500 objects, I get a strange windows exception. It says the operation copmleted successfully at my constructor line. The program doesn't run or anything. I'm assuming it has something to do with memory. Each object has 32 indices and 8 vertices, so that 640,000 bytes or whatever vertices… >>> More
Car-like Physics - Basic Maths to Simulate Steering

as seen on Game Development - Search for 'Game Development'
As my program stands I have a cube which I can control using keyboard input. I can make it move left, right, up, down, back, fourth along the axis only. I can also rotate the cube either left or right; all the translations and rotations are implemented using glm. if (keys[VK_LEFT]) //move cube along… >>> More
Unable to access a primitive array inside a custom class from a UIViewController instance

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello! I have made a subclass of NSObject that is meant to be the model of my application. The class has a few methods and on instance primitive array as such: @interface Cube : NSObject { int cubeState[5][2][2]; } - (id)printContent; @end @implementation Cube - (void)init { if (self… >>> More