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
Author
Message
Posted Saturday, August 9, 2014 4:56 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, December 18, 2014 8:55 AM
Points: 8, Visits: 57
Hello,

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
Kavitha


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

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: 2 days ago @ 4:50 AM
Points: 635, Visits: 1,213
This guide will take you through the whole process of adding calculations (and everything else):
http://technet.microsoft.com/en-us/library/ms170208.aspx

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