1 Reply Latest reply: Jan 16, 2013 3:12 AM by Jagan Nalla RSS

    Variables and Set Analysis Question

      Hello,

       

      I have what I imagine is a pretty simple question, but I am not having any luck putting this together.  I have the start of a very basic application, with a Date table and a Sales table, as shown below;

       

      Date:

      LOAD DateId,

          DateShort,

          FiscalWeekId,

          FiscalMonthId,

          FiscalQuarterId,

          FiscalHalfId,

          FiscalYearId,

      SQL SELECT DateId,

          DateShort,

          FiscalWeekId,

          FiscalMonthId,

          FiscalQuarterId,

          FiscalHalfId,

          FiscalYearId,

      FROM EDW.Logical."vEDW_D_Date_v2";

       

      Facts:

      LOAD

                DateId,

          LocationNum,

          TimeId,

          TranNum,

          Quantity,

          ExtGrossDollars,

          ExtDiscountDollars,

          ExtNetDollars,

          ExtCostDollars,

          Margin,

          ExtNetDollars_POS,

          ExtNetDollars_Concierge;

      SQL SELECT

                DateId,

          LocationNum,

          TimeId,

          TranNum,

          Quantity,

          ExtGrossDollars,

          ExtDiscountDollars,

          ExtNetDollars,

          ExtCostDollars,

          Margin

      FROM EDW.Logical.vEDW_R_Sales_v2

      inner join

                EDW.Logical.vEDW_D_Location_v2

      on  vEDW_D_Location_v2.Location_Key_As_Was          = vEDW_R_Sales_v2.Location_Key_As_Was

      where DateId >= 20100131

       

      I can create a chart, for example, aggregating to Date/Location and after adding list boxes for various fiscal perios (Month, Qtr, etc.) I can use these to filter the chart.

       

      However, what if I want set up a chart which would always show sales for only the most recent day of sales loaded, how would I do this?  I imagine it's a combination of variables and set analysis, but I have not been able to get anything to work.

       

      Thanks!

      Chris