Cube load

roselyn12 · Nov 22nd 2015, 1:51pm

Hello Team,

Is is possible to load historical data into a cube by deleting data from that data 1st before putting new data?
Suppose we have the following data for November 16:

Invoice Num: inm123
Transaction DATE: 11/16/2015
Location Country: Germany
Location Center: Mainz
Salesman_Code: empty
Salesman: empty
#Values: 123

One week past and the data updated into:

Invoice Num: inm123Transaction
DATE: 11/16/2015Location
Country: Germany
Location Center: Mainz
Salesman_Code: s123
Salesman: rose
#Values: 123

If this scenario happens again and again due to the data transfer so manually splashing it to zero is not a good idea.
What i want is during cube load if im having a java script that is loading a from a specific date can I delete data for those data then insert the updated value?

Thanks
Rose

laloune · Nov 23rd 2015, 10:45am

Hi Rose,

if you can read german you can check this out: Rule for copying cube data for planning

if not then I'll try to explain it again for you.

laloune · Nov 23rd 2015, 1:34pm

use a Cubeslice to delete the complete Slice of the cube. Then load the slice again.

this is like a "partial" update

roselyn12 · Nov 23rd 2015, 2:24pm

is it possible to do during cube load??

laloune · Nov 23rd 2015, 10:46pm

what do you mean "during cube load"?

alternative would be to delete each cell line by line but in case of large data volume it can be very loooong.

let's take a look on an example:

Regions;Year;Datatype;Measure;#Value
France;2015;1;Actual;Turnover;120
France;2015;2;Actual;Turnover;140
France;2015;3;Actual;Turnover;100
Germany;2015;1;Actual;Turnover;160
Germany;2015;2;Actual;Turnover;150
Germany;2015;3;Actual;Turnover;90

using a cube slice on Germany;2015 as a source for a delete load, this would delete the 3 last cells.

now if I have the following in my extract (constant table, or something similar) :

Germany;2015;2;Actual;Turnover;150
Germany;2015;3;Actual;Turnover;90

and use as a source for a delete load, then only those 2 cells are going to be deleted.

is this more clear?

roselyn12 · Nov 24th 2015, 2:22pm

Thank you laloune this is more clear to me.

But is it possible to have a data range in deleting data let november 1 - 3 using cubeslice?

Thanks

laloune · Nov 24th 2015, 9:57pm

you mean from November 1st to November 3rd?

If your dimension base elements are dates you can easily generate a regex that will query all dates in the ranges, for instance:

^01.11.2015|02.11.2015|03.11.2015$ (should give it a try, this could be some other syntax

this in a cubeslice will allow you to query the range

Cube load

Cube load

Share

Similar Threads