PDA

View Full Version : How do I do this



Kdankwah
2014-11-19, 10:45 PM
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?



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









Thanks in advance