Home Forums Data Warehousing Analysis Services Calculated Resource Costs month by month RE: Calculated Resource Costs month by month

  • April 22, 2013 at 3:35 pm

    #1608888

    Sol_Web_Solutions (4/22/2013)

    End goal is >> show month by month breakout of resource costs.

    We have resource costs that are displayed via 3 columns:

    1. TotalCost

    2. Start Date

    3. FinishDate

    I am working with the time dimension that gives me the 12 months out of the year, so the column headers are showing up, but the costs are the same per month. I don't have the month by month splits yet, which is what I'd like to do.

    Is this possible via SSAS?

    Should be if the data is loaded in the DW correctly. Hard to say from here, can't see what you see.