I would like to bring attribute "Text 1" field identified in Entity dimension into a Cube view.
When users run a Cube View, they should be able to see Entity as a Column name and the “Text 1” field attribute which is identified in entity
Hi Sean - you will be able to do this with a Dynamic Calc. See below for screenshots of the setup. On your CV column, you would reference this member with one of the annotation View members, such as U8#Ent_Text1:V#Annotation.
Dim entity As String = api.Pov.entity.Name
Dim entityId As Integer = api.Pov.entity.MemberId
Dim entityText1 As String = api.entity.Text(entityId,1).ToString