creating a boolean measure

Hello,

I've created a new measure where my source column is of type Boolean and have selected aggregate type "None" (simply because I just need to show true or false while browsing my cube).

However, when i deploy my cube and browse it, it shows empty cells against my dimension.

It doesnt allow me to select aggregate "First Non Empty Value" and i get a messag saying "Semi-additive measure requires a time dimension"

any suggestions would be appreciated...This is my desired output

Accepted

Submission 1 True

Submission 2 False

Submission 3 True

.

.

.

and so on. where Submission is my dimension and Accepted is my Measure.

TIA

russzee

Any reason why you couldn't create, rather than a measure, a dimension like "AcceptStatus", with members "True" and "False"?|||

Deepak,

Thanks for your reply.. Thats a very valid question. I forgot to eloborate that I already have a dimension called "Accepted" and it works just fine while browsing the cube against "Submission".

However , my client application is Performance Point Dashboard Designer so I need to convert this to a Measure to be able to use it as a KPI in the client application.

Thanks

russzee

|||In that case, you could create a calculated measure, which returns a value based on the member of "Accepted" with data, rather than creating a cube measure. If you provide more details of your data and of the required KPI, that would help.