Compare date in column algorithm

William Le

Dear All,

 

I have 2 cube, the first cube is a date cube with one dimension is article, the second cube is single cube with 2 dimensions are Month and article. I want to make a new single cube with 2 dimensions are Month and article. i want to fill the value in new cube by second cube with the logic is if the month in second cube equal or greater than date in first cube for the same article, the value in new cube will equal to the value in first cube. Is it possible to do by column algorithm. And in the algorithm, do all the blocks need to the same dimension? Thank you very much.

Samuele Marchetto

Hi, you need 2 service cubes: a cube (single), by Article, where you write the month of the date of first cube as single (that means, date 01/01/2018 must be converted in 201.801 via ETL or Nexel), a cube (single), by Month and Article, where you write the value of Month entity for every article (view procstec1 attached)

 

Then you can calculate via dataflow your algorithm (view procstep2 attached)

 

 

In my example I obtain this:

 

 

Bye