AnsweredAssumed Answered

Procedure Process Speed

Question asked by louisejust on Jan 23, 2020
Latest reply on Jan 23, 2020 by louisejust

I have a process in a Procedure that puts a 1 into a cube where the outlet has data.   This procedure is running very slow and I am trying to make it faster.  I was previously using an if statement to say if that data in the first cube for the required date range then 1 else 0.  This was very slow.  I have created a cube that contains only the data that needs the 1.  Therefore the if statement is no longer required.  When I use the algorythm a=1, I would expect to see a 1 next to all detail from the cube, but I don't.  How can I achieve this without the If statement.  See attached is the process with the if statement.  Cube A contains only the required data and I want to put a 1 into cube B, thanks. 

Attachments

Outcomes