I have a measure called Actual Hours in my cube. I need to create a calculation in the cube for Budget Hour which needs to be something like
Budget Hour = (Last Year's Actual Hour)*1.25 and when I drill down(to say Month level) it should be Budget Hour = (Last Month's Actual Hour)*1.25 etc.
Any idea how to go about this? Any help would be truly appreciated. Thanks in advance.
View Complete Post