workflow

Options
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.

Answers

  • Unknown
    Unknown Active Partner
    Options

    Hi Niharika,

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

    Best,
    Jonathan

  • 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.