This discussion is archived
9 Replies Latest reply: Feb 19, 2013 5:50 PM by 960225 RSS

Where condition for a column in BMM

960225 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points