How to get users if time spent null

Questions & Answers
1

Hi!

I am importing jira users from SQL, how to search for them in the logged by dimension and, if there is no time spent, return 0

(
  [Logged by].[User].GetMemberByKey(
    [User AD].CurrentMember.Key
  ),
  [User AD].CurrentMember
)

I have experimented with these filters but an empty value is returned

2

Hi @clank232

Did you import the data in the Jira Issues cube or is this a new custom cube?

You should check that the Keys of the “User AD” dimension members are the same as the Keys from the “Logged by” dimension “User” members. It could be the case that the “User AD” members contain the names as keys, not the original keys themselves.

If, however, the keys match up, then you can use a formula like this together with the [User AD] dimension:

(
  [Measures].[Hours spent],
  [Logged by].[User].GetMemberByKey(
    [User AD].CurrentMember.Key
  )
)

​Best regards,
​Nauris