Skip to main content
S
Sean
Newcomer
February 7, 2022

How to bring attribute "Text" fields value into a Cube View

  • February 7, 2022
  • 1 reply
  • 0 views

Hello,

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 entityCapture 2.PNG

1 reply

E
OneStream Employee
EricOsmanskiOneStream Employee
OneStream Employee
February 7, 2022

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.

EricOsmanski_0-1644262581929.png

EricOsmanski_1-1644262647682.png

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

Return entityText1

 

 

    S
    SeanAuthor
    Newcomer
    February 8, 2022

    Hi Eric,

    Thank you very much!! It is working exactly the way I need after following all your steps.  Really appreciate taking your time and effort to answer my question.

    Best Regards,

    Sean

    Sean

      Terms & ConditionsAccessibility statement