Skip to main content
Newcomer
Aug 2, 2025 9:56 PM UTC
Solved

Syntax to pull entity description where entity NOT the POV entity

Is there a syntax to lookup the description of an entity that is NOT the pov entity?  In the example below the pov_entity is XXXXXXX_Canada, but the entity I want to pull a description from is 00250.  I am writing a rule in a ud8 member to try to pull this.

Thank you,

rhankeyAnswer
Newcomer
Aug 4, 2025 5:02 PM UTC

If I understand correctly, your UD2 member names match the names of Entity members, and you want to surface the Entity descriptions for that of the UD2 members.

I can think of at least two obvious options.

Dynamically - Create a Dynamically Calculated member in UD8 that returns somthing like api.Members.GetMember(DimType.Entity.Id,api.Pov.UD2.MemberId).Description.  You would surface it into your Cube View as U8#[YourEntityDescFromUD2Member]:V#Annotation

Metadata automation - wriite a Business Rule that copies that Entity Descriptions over to the matching UD2 members.  You can choose to copy to the destination Description, a cultural description, or a Text[n] property.  If copying to Descriptions, then simply display Member Descriptions for UD2.  If copying to a Text[n], you would still need a Dynamic Calc member to surface the description as an Annotation. 

5 replies

Expert
Aug 4, 2025 10:20 AM UTC

The function XFMemberProperty might help you (search this forum for more info). It will probably mean you have to add the descriptions to a Text field though.

BobNelsonAuthor
Newcomer
Aug 4, 2025 1:26 PM UTC

Interesting idea, but ...

If there is no other option, we will have to weigh whether having a description appear on a report is worth having to burn a text field over.  I'm hoping there's another option out there, though.

rhankeyAnswer
Newcomer
Aug 4, 2025 5:02 PM UTC

If I understand correctly, your UD2 member names match the names of Entity members, and you want to surface the Entity descriptions for that of the UD2 members.

I can think of at least two obvious options.

Dynamically - Create a Dynamically Calculated member in UD8 that returns somthing like api.Members.GetMember(DimType.Entity.Id,api.Pov.UD2.MemberId).Description.  You would surface it into your Cube View as U8#[YourEntityDescFromUD2Member]:V#Annotation

Metadata automation - wriite a Business Rule that copies that Entity Descriptions over to the matching UD2 members.  You can choose to copy to the destination Description, a cultural description, or a Text[n] property.  If copying to Descriptions, then simply display Member Descriptions for UD2.  If copying to a Text[n], you would still need a Dynamic Calc member to surface the description as an Annotation.