Getting a count of users each day in Mondrian MDX

Posted by user1874144 on Stack Overflow See other posts from Stack Overflow or by user1874144
Published on 2012-12-04T00:03:39Z Indexed on 2012/12/05 5:04 UTC
Read the original article Hit count: 180

Filed under:

mdx

|

olap

|

data-warehouse

|

pentaho

|

mondrian

I'm trying to write a query to give me the total number of users for each customer per day.

Here is what I have so far, which for each customer/day combination is giving the total number of user dimension entries without splitting them up by customer/day.

WITH MEMBER [Measures].[MyUserCount]
  AS COUNT(Descendants([User].CurrentMember, [User].[User Name]), INCLUDEEMPTY)
SELECT
  NON EMPTY CrossJoin([Date].[Date].Members, [Customer].[Customer Name].Members) ON ROWS,
  {[Measures].[MyUserCount]} on COLUMNS
FROM
  [Users]

© Stack Overflow or respective owner

Related posts about mdx

MDX Studio download #mdx #ssas

as seen on SQL Blog - Search for 'SQL Blog'
Short version: the latest available version of MDX Studio can be downloaded from http://www.sqlbi.com/tools/mdx-studio/ Long version: Last week Stacia Misner twitted that the online version of MDX Studio was no longer available. It was hosted on http://mdx.mosha.com. It was a sad news, and it is… >>> More
MDX: Problem filtering results in MDX query used in Reporting Services query

as seen on Stack Overflow - Search for 'Stack Overflow'
Why aren't my results being filtered by the members from my [Group Hierarchy] returned via the filter() statment below? SELECT NON EMPTY {[Measures].[Group Count], [Measures].[Overall Group Count] } ON COLUMNS, NON EMPTY { [Survey].[Surveys By Year].[Survey Year].ALLMEMBERS… >>> More
Stairway to MDX - STEP 1: Getting Started with MDX

as seen on SQL Server Central - Search for 'SQL Server Central'
To learn MDX, there is really no alternative to installing the system and trying out the statements, and experimenting. William Pearson, the well-known expert on MDX, kicks off a stairway series on this important topic by getting you running from a standing start. NEW! SQL… >>> More
Converting #MDX to #DAX and PowerPivot Workshop online #ppws

as seen on SQL Blog - Search for 'SQL Blog'
I just published the article Converting MDX to DAX – First Steps on the renewed SQLBI web site about converting MDX to DAX. The reason is that with BISM Tabular in Analysis Services 2012 you will be able to write queries in both DAX and MDX. If you already know MDX, you might wonder how to “translate”… >>> More
Attribute Overwriting in MDX

as seen on SQL Blog - Search for 'SQL Blog'
Jeffrey Wang wrote a great blog post about attribute overwriting in MDX that is very clear and full of helpful pictures to show what happens when you write an MDX statement that writes into your multidimensional space. This is very common in an MDX Script and if you tried to customize the DateTool… >>> More

Related posts about olap

MDX lekérdezések az Oracle OLAP-hoz

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Az Oracle OpenWord-ön, 2009. október 12-én jelentette be az Oracle, hogy elkészült a Simba Technologies MDX eszköze az Oracle OLAP eléréséhez: Oracle and Simba Technologies Introduce MDX Provider for Oracle® OLAP. Az MDX Provider for Oracle® OLAP eszközzel közvetlenül az Excel felületrol lehet elérni… >>> More
An OLAP client!

as seen on SQL Blog - Search for 'SQL Blog'
While surfing CodePlex I’ve come across a very interesting tool for all BI Developers who misses a decent OLAP client where to write, run & test MDX queries http://ranetuilibraryolap.codeplex.com/ I’ve not tested it yet, but I’ll surely do this week and I’ll post my impressions ASAP. The first… >>> More
An OLAP client!

as seen on SQL Blog - Search for 'SQL Blog'
While surfing CodePlex I’ve come across a very interesting tool for all BI Developers who misses a decent OLAP client where to write, run & test MDX queries http://ranetuilibraryolap.codeplex.com/ I’ve not tested it yet, but I’ll surely do this week and I’ll post my impressions ASAP. The first… >>> More
OWB 11gR2 – OLAP and Simba

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Oracle Warehouse Builder was the first ETL product to provide a single integrated and complete environment for managing enterprise data warehouse solutions that also incorporate multi-dimensional schemas. The OWB 11gR2 release provides Oracle OLAP 11g deployment for multi-dimensional models (in addition… >>> More
Building dynamic OLAP data marts on-the-fly

as seen on SQL Blogcasts - Search for 'SQL Blogcasts'
At the forthcoming SQLBits conference, I will be presenting a session on how to dynamically build an OLAP data mart on-the-fly. This blog entry is intended to clarify exactly what I mean by an OLAP data mart, why you may need to build them on-the-fly and finally outline the steps needed to build… >>> More