I am using Powerpivot and OLAP cube formulas. My problem is that I have a flat file table (summed already) that I want to insert the contents on the "outstanding enc" line on the table. The table is by month, category and department. Any ideas of what cube functions to use to insert the data from the flat file into the cube table without aggregation?
Thanks in advance
Flat file table: | |||||
Month | Year | Department | Month to date | Year to date | Category |
September | 2014 | 21030000 | 0.00 | 18,241.00 | Outstanding Enc |
September | 2014 | 31020000 | 1,500.00 | 1,500.00 | Outstanding Enc |
September | 2014 | 32020000 | 0.00 | 0.00 | Outstanding Enc |
September | 2014 | 34020000 | 0.00 | 20.00 | Outstanding Enc |
September | 2014 | 38020000 | 0.00 | 0.00 | Outstanding Enc |
September | 2014 | 38030000 | 0.00 | 303.00 | Outstanding Enc |
September | 2014 | 41020000 | 0.00 | 0.00 | Outstanding Enc |
September | 2015 | 43030000 | 200,000.00 | 611,716.00 | Outstanding Enc |
September | 2015 | 43050000 | 25,400.00 | 25,400.00 | Outstanding Enc |
September | 2015 | 43060000 | 0.00 | 760.00 | Outstanding Enc |
September | 2015 | 43070000 | -28,992.00 | 30,614.00 | Outstanding Enc |
Cube table | |||||
FY2015 | FY2014 | ||||
Department | Category | Month | Ytd | Month | Ytd |
0 | 0 | 0 | 0 | ||