How do I do this

Kdankwah

New member
Joined
Nov 19, 2014
Messages
1
Reaction score
0
Points
0
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:
MonthYearDepartmentMonth to dateYear to dateCategory
September2014210300000.0018,241.00Outstanding Enc
September2014310200001,500.001,500.00Outstanding Enc
September2014320200000.000.00Outstanding Enc
September2014340200000.0020.00Outstanding Enc
September2014380200000.000.00Outstanding Enc
September2014380300000.00303.00Outstanding Enc
September2014410200000.000.00Outstanding Enc
September201543030000200,000.00611,716.00Outstanding Enc
September20154305000025,400.0025,400.00Outstanding Enc
September2015430600000.00760.00Outstanding Enc
September201543070000-28,992.0030,614.00Outstanding Enc
Cube table
FY2015FY2014
DepartmentCategoryMonthYtdMonthYtd
0000
Thanks in advance
 
Top