Who's your daddy and what does it do? 🙂
First, create a UD8 member that will just return the current POV account name with type DynamicCalc and Member Formula as follows:
If api.View.IsAnnotationType Then
' if you wanted to target a specific view you could use this instead:
' if api.POV.View.Name.XFEqualsIgnoreCase("Annotation") then
return api.POV.Account.Description
end ifThen create your CV. I'm going to hide icons:
And hide row headers:
First and last columns are up to you, just set the central one like this:
And that's it! You can play around with formatting to emphasize the central column.
NicolasArgente RobbSalzmann would you hire me? 😁
PS: there may be a way to do this with custom DataCell functions, without the extra UD8 member, but I couldn't get it to work because the returned cell is always treated as a number for some reason.
Ahahha!! Good job Jack! and like always, thanks for sharing!
JackLacava Any idea how to make this work when the Account is a Dynamic Calc?
In that case, the code I put on UD8 will have to go in the Account formula. If that formula already replies to Annotation views, you'll have to point to a particular one of them and check for that in the code as I described in the comment.
As I mentioned, there is probably a way to make this work with custom GetDataCell functions instead, but I couldn't make it work.
Thank you!! It worked
Hello Jack. I have one doubt about this solution. It is possible to do it with attribute members? I'm trying to do it with attribute members in UD1 and the descriptions are not displayed.
I honestly don't know - Attribute Members do all sort of black magic and in many ways they're not real members. I note that in the doc it says:
"Attributes can only be called through a business rule using a DataBuffer. The function property includeUDAttributeMembersWhenUsingAll can be enabled to allow rules to reference the attribute results for use in formulas."
Rather than going to the (expensive) trouble of retrieving a buffer and inspecting it, I would try to use the brapi functions to read metadata. That assumes the member ID exists though...
' to make sure you actually get an ID in pov with attribute members, uncomment next line and check errorlog
' BrApi.ErrorLog.LogMessage(si, $"ud1 id is: {api.Pov.UD1.MemberId}")
Dim mbr As Member = api.Members.GetMember(DimTypeID.UD1, api.Pov.UD1.MemberId)
return mbr.Description