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 Query Expand / Collapse
Posted Saturday, August 9, 2014 4:56 AM


Group: General Forum Members
Last Login: Monday, January 19, 2015 9:19 AM
Points: 10, Visits: 70

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
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Today @ 7:34 AM
Points: 695, Visits: 1,291
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