August 9, 2014 at 4:56 am
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
August 12, 2014 at 8:43 am
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.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply