Skip to main content
Member
Apr 5, 2022 3:18 PM UTC

Cube view column headers

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

8 replies

Veteran
Apr 5, 2022 4:14 PM UTC

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
Apr 5, 2022 4:15 PM UTC

Similar setting is available in quick views as well. 

Apr 5, 2022 4:19 PM UTC

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

PatrickWWiggett_0-1649175475514.png

 

Apr 5, 2022 4:25 PM UTC

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
Apr 5, 2022 4:42 PM UTC

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).

 

 

Member
Apr 5, 2022 8:53 PM UTC

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

Contributor
Apr 11, 2023 5:38 PM UTC

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 1:02 AM UTC

No not really.