6 Replies Latest reply: Dec 24, 2013 5:49 AM by Harleen Singh RSS

    data model suggestion

    Harleen Singh

      Hello,

                  i have a fact table in the middle with a Date field and Date field is linked with Ca lander.

       

      I have following fields in Fact table. So here date field is linked with Master Calender

       

      Rno

      Date,

      Quantity

       

      Now what i want a Flag in a data model where Quantity is greater than 744 in a month for particular RNo. But, if i do group by monthyear than my data model will convert into monthyear level which i don't want. I want to keep my data model into Date level.

       

       

      What should i do in this case?

       

       

      thanks

      Lavi