Prologika Forums

This is my desired output in BSM 2005

                                 Actual

Submission 1             True
Submission 2             False
Submission 3             True

I'm trying to use a boolean dimension column in Analysis Services 2005
to create a new measure so that I can use that new measure in BSM 2005
as a KPI to get the desired output above.

I tried creating a new measure in SSAS 2005 and selected my aggregate
type as "None" (since i only want true or false displayed) but while
browsing it in my cube it doesnt show any data.

Even when i use the measure as a KPI in BSM 2005 , blank data.

Any ideas / suggestions would be much appreciated !

Thanks
russzzee