9 Replies Latest reply: Feb 19, 2013 7:50 PM by ABujji RSS

    Where condition for a column in BMM

      Hi Gurus,

      I have a requirement where in the BMM(The LTS for this logical table is say 'Fact'), I need a logical column with the following definition.

      count(Dim.status) where Dim.status = ' Accepted' (I didnt add the Dim table to the LTS yet, should I?)

      I know that we can do a count(Dim.status) in the column source . but for the where Dim.status = ' Accepted' part im not sure what to do.

      Should I bring the Dim table as a LTS and define the 'where' condition in the content tab? will that work?

      but what if I have another logical column where I need dim.Status = 'Declined'( we have many more status)

      Plz help