Forum Discussion

Sean's avatar
Sean
New Contributor
3 years ago

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

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 “Tex...
Reports
salmankhanani's avatar
salmankhanani
New Contributor II

Hi Eric - can you explain how this can be altered to pull the Text 1 - Text 8 fields from the account dimension rather than entity?

Thanks!

EricOsmanski's avatar
EricOsmanski
Valued Contributor
9 months ago

Hello - you should just be able to change the code to reference Account (or another dimension) as well as the particular text field you are looking to retrieve:

Dim acct As String = api.Pov.Account.Name
Dim acctId As Integer = api.Pov.Account.MemberId
Dim acctText1 As String = api.Account.Text(acctId,1)

Return acctText1