workflow
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.
0
Answers
-
Hi Niharika,
You can retrieve the current date with the column algorithm: today(). This functionality can also be used in dataflows.
Best,
Jonathan0 -
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.
0