AnsweredAssumed Answered

Compare date in column algorithm

Question asked by william.le on Mar 19, 2018
Latest reply on Mar 29, 2018 by marcsamu

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.

Outcomes