workflow

Question

Hi.. please answer this question.  have cube (date) which holds the last date for submission of a plan. what  I want is, I want to write a procedure and schedule it on daily basis and what that procedure should do is-- it should check if today date is the last date for submission and if it is then it should lock all my plans. my doubt is how do I compare my system's date with the date holded by my cube. thanks in advance.

unknown · Answer

Hi Jonathan Baetens.

I did that already what I didn't understand is how to compare this two cubes , but now I solved that by taking another cube  and In the dataflow statement I wrote if condition. I got the appropriate result. thanks for your reply.

unknown · Answer

Hi Niharika,

You can retrieve the current date with the column algorithm: today(). This functionality can also be used in dataflows.

Best,
Jonathan