TM1 Forum

Hello,
Is there a way to show an attribute of the element next to the Element in the View.
For example,John claimed $60 travel expenses in June and Eric is John's Manager.
I would like to see

Name Manager June
John Eric 60.

Currently, I have been using DBRA to get the Manager's name after slicing the view.

telula wrote:Hello,
Is there a way to show an attribute of the element next to the Element in the View.
For example,John claimed $60 travel expenses in June and Eric is John's Manager.
I would like to see

Name Manager June
John Eric 60.

Currently, I have been using DBRA to get the Manager's name after slicing the view.

Short answer, no.

Longer answer, you could do what you're looking for in a cube which had a dimension for the staff and another dimension for their manager, with the value written to the relevant combination of elements. Other than that your existing method is the one you'd need to go with.

You could also do it in good old excel using the DBRA function. Alan's solution of using another cube to gather the information is however probably the better way to go.

Or create an alias that was the element name and the attribute combined and just use that in your views.

Steve Rowe wrote:Or create an alias that was the element name and the attribute combined and just use that in your views.

That's good lateral thinkin'. the only issue will be that when you change an alias you may randomly get key error messages in slices until the server is rebooted, but I can't imagine managers changing on a regular basis.

jim wood wrote:You could also do it in good old excel using the DBRA function. Alan's solution of using another cube to gather the information is however probably the better way to go.

Awake now. Apologies.

Another approach could be to have the management hierarchy layered in your employee dimension.