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:

      Load

      max(GLDATE) as vGLDATE

      Resident Production;

       

       

      Current Budget:

      Load *

      Resident Budget

      Where vGLDATE < BUDGET_DATE;

       


      Thanks,

      Steve