Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Creating measures in universe

Hi,

I'm trying to create some measures in my universe but I'm having trouble on how to go about it. I'm new to this so bear with me:)

I have two Y/N flags in my table that I want to be able to do counts on I created 1 measure, "RecordCount", as count(*). I then created two additional dimension objects. "1Status" and "2Status".

1Status = Case when Field1 = 'Y' then '1At Goal' else '1Not at Goal' End

2Status = Case when Field2 = 'Y' then '2At Goal' else 2Not at Goal' End.

I also have an AgeBucket dimension object "AgeBuckets"

AgeBuckets =

CASE WHEN @Select(CurrentAge) between 1 and 30 then 'Ages 1-30'

     WHEN @Select(CurrentAge) between 31 and 40  THEN 'Ages 31-40'

     WHEN @Select(CurrentAge) between 41 and 50  THEN 'Ages 41-50'

     WHEN @Select(CurrentAge) between 51 and 60  THEN 'Ages 51 - 60'

     WHEN @Select(CurrentAge)> 60 THEN 'Ages > 60'

END

In my webi report i created a table with "AgeBuckets","1Status" and "RecordCount" and another table with "AgeBuckets", "2Status" and "RecordCount".

It seems to be working fine until I add "1Status" and "2Status" as a selection in the Filter Bar. Then the counts don't work.

Do I have it setup correctly in the universe?

Any help would be greatly appreciated.

thanks.

Former Member
Not what you were looking for? View more on this topic or Ask a question