07-20-2022 08:51 PM
07-21-2022 10:46 AM - edited 07-21-2022 11:01 AM
Did you try this:
07-25-2022 10:24 PM
Hi Christian,
Thanks for your reply. I have used the Header overrides function for other reports. What I am actually looking for is inserting a sub - header in a column/row intersection cell. For example below the yellow cells are the usual Column and Row Headers. But the user needs the headers highlighted in Blue in the report. Please advise if you come across this scenario where we can insert headers in column/row intersection cells in Cube Views. Thanks Sam
07-26-2022 05:10 PM
Ah, ok, I misunderstood.
Normally, a cell in cubeview is a number, but your problem can be solved using an text view member like annotation: a#cost:v#annotation is of type text.
You can also work with a parameter based cell, you then just need a list type parameter that interprets integers as the needed labels. I.e. 1 = Closing Balance, 2 = Disposal, …
I’m not at my notebook right now, but I will post a sample the next days.
07-27-2022 12:08 AM
Hi Christian, Thanks for your reply. I already tried the Annotation option and it works only for one period. As you may be aware if we change the period the text in annotation disappears. I have attached the actual version of the CV that I am working on. I have worked out the headers in rows and columns highlighted in green. My issue is the headers in blue color in bottom two sections. Please let me know if you came across similar type of CV or if we need to use Report Designer to fix this issue. Thanks Sam
07-27-2022 05:28 AM - edited 07-27-2022 07:59 AM
The Annotation doesn’t need to be stored, it can be a member formula. Then it will be the same for all periods (and all other dim members).
07-27-2022 11:43 AM - edited 07-27-2022 11:49 AM
or even better:
If api.View.IsAnnotationType Then
Return api.Pov.Flow.Name
End If
If api.View.IsAnnotationType Then
Return api.Pov.Flow.Description
End If