Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

MDX Query Expand / Collapse
Posted Saturday, August 9, 2014 4:56 AM


Group: General Forum Members
Last Login: Tuesday, January 27, 2015 8:20 AM
Points: 10, Visits: 71

I am new to MDX. Could some one please help me in writing code for following formula. I have created a cube but dont know how to add a calculated value to the fact table.

Attached are the screen shots of the cube. And the formula which i need to implement.

Thanks and Regards

  Post Attachments 
Formula.docx (6 views, 64.56 KB)
Post #1601383
Posted Tuesday, August 12, 2014 8:43 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 3:41 AM
Points: 1,273, Visits: 2,374
This guide will take you through the whole process of adding calculations (and everything else):

You have nothing but IDs in your Measure Group and no actual measures.

In order to get some meaningful information you need to re-evaluate the model of your cube. Something as simple as a count of records in your fact table and then linking it to the dimensions to provide context would be a start. Until you have done this you won't even be able to start thinking about MDX calculations.

Go through the tutorial I linked to and you'll get a better idea of how a useful cube is structured.

I'm on LinkedIn
Post #1602317
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse