Post reply

Cube/DWH Design Problem

  • November 25, 2009 at 7:42 am

    #206714

    Hi,

    I have fact table with a contract value. Also I have a dimension with a contract states

    - Actual

    - Replace

    - Canceled

    Now I have to display a ratio with following calculation

    ratio = Actual - Replaced - Canceled

    I have a cube which can be used to see the contract values by time, state, region etc.

    Is there a way in Analysis Services to make such a calculation in a cube or do I have to change my fact table or create a new one.

    Thanks for every hint

  • December 4, 2009 at 3:39 pm

    #1088073

    I'm sorry but I don't understand the question. Could you give more information about what kind of data is in the Actual, Replace, and Cancelled fields? Some concrete examples of the data and what the calculations would result in would be very helpful.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply