3 Replies Latest reply: Nov 15, 2013 11:43 AM by Aurélien Martinez RSS

    Creating a variable from a Load

    Steve Zagzebski

      I need take the Max Date of a table (Master Cube table below) and use that date in my where clause for another table.


      I know my script is NOT right below. But how do I get the vGLDATE field from the Master Cube into the Where clause of my Current Budget table


      Master Cube:


      max(GLDATE) as vGLDATE

      Resident Production;



      Current Budget:

      Load *

      Resident Budget

      Where vGLDATE < BUDGET_DATE;