Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

MDX: SSRS Expression: Count Dimension members based on other Dimension Expand / Collapse
Author
Message
Posted Wednesday, September 25, 2013 7:22 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, September 30, 2013 1:33 AM
Points: 10, Visits: 15
Hi there,
I am pretty new to mdx expressions, and am currently trying to write a calculated member in SSRS (2012) that does pretty much the following:

Dimension1 - CampaignNames
Dimension2 - Customers
Dimension3 - ContactDate


now out of These three i want to see the Number(Count) of Customers that have been Contacted (for which there is a ContactDate, so basically where ContactDate is not Unknown or Null).
Logicaly maybe something like this

Count(Customers) where ContactDate NonEmpty
( I am not quite sure if i'm typing it correctly, this is just how i Thing it's done for now. i don't know if this would also exclude NULL Values.)
I want this to be done Relative to the CampaignName though, so when i put it on a table later, i could Group by Campaign Name and then Customers.
Post #1498343
Posted Wednesday, September 25, 2013 11:51 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Wednesday, October 22, 2014 3:15 PM
Points: 3,166, Visits: 1,378
Just to clarify, are you looking to do this in a SSRS dataset containing an MDX query or within a table in SSRS.

If it is the MDX route then please list out the dimension and measures you are using for this. Please show any code you have tried to perform this task.

Fitz
Post #1498518
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse