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

Trending Depletions Expand / Collapse
Author
Message
Posted Monday, July 8, 2013 1:37 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, July 26, 2013 9:42 AM
Points: 1, Visits: 29
First let me start by saying I am new to SSIS/SSAS. I have a datamart build showing stock sales and depletions. I have a dim table that has my date information. The atomic level is to the month on the DimDate table. I also have my Depletions Fact table. I have built this into a cube but need to add a Trend calculation for the last three years of data.

I will then be using a matrix in SSRS to group by year and month.

I am not really sure the best way to do this. The report I am converting used the Excel TREND function. I am rebuilding the report in SSRS and have everything done but this.
Post #1471342
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse