Skip to main content
Member
April 5, 2022

Cube view column headers

  • April 5, 2022
  • 5 replies
  • 0 views

When I develop cube views, is it possible to have the description in the header for the data in the rows, for instance first column might be Account, second column Customer.  When I extract the cube view the header for these is blank and I have to manually insert a description to the dimension is relating.  Same issue occurs with quickviews.

 

Any solutions

5 replies

Veteran
April 5, 2022

General Setings > Header Text > choose appropriate setting here

1. Name

2. Description

3. Name and Description

This setting would drive the display of headers in your cube view.

Hope this helps.

Thanks.

 

Veteran
April 5, 2022

Similar setting is available in quick views as well. 

Newcomer
April 5, 2022

Have you tried using the different levels in the member filter builders? These allow you to use different dimensions. 

PatrickWWiggett_0-1649175475514.png

 

Newcomer
April 5, 2022

Alternatively I sometimes use a separate column with the V#Annotation and then a unique metadata member which then returns the appropriate dimension/member property that you want:

If api.View.IsAnnotationType() Then

    Return api.pov.UD1.Name

Else

    Return api.Data.CreateDataCellObject(0.0,True, False)

End If

(That's the code your dynamiccalc will need)

Member
April 5, 2022

You can also add the row at the first position: Advance > Rows Tab:

1)  Row Members:  Member Expansion 1:  Primary Dimension Type Account:  A#None:Name(Account)

2) Row Members:  Member Expansion 2:  Nested Member Expansion 2:  U1#None:Name(Customer).

 

 

Newcomer
April 5, 2022

That's the only way I can think of. I think this was answered on a different yet similar post here.

Contributor
April 11, 2023

Did you ever get an answer for this?  I think the replies didn't really address it.  I'm trying to do the same thing and have a row description on the same line as the column headers.  Like I need it to be like a generic "Departments" on the same line as the column headers, and then of course the specific departments like "700 - Selling, 800-General Admin" are already going correcting down the rows.

tdugasAuthor
Member
May 11, 2023

No not really.