is there a solution yet to show only what I want in a column header? I do not want to show the "2018" because behind that is a reference year 2017. Is it possible not to show the 2018?
Hi Hannes. Are you referring to the defaulted header titles which appear as soon as you create and add a cube a dataview, with an entity aligned by column? If so, no - I don't think so.
In these instances I use a workaround, like a headerless dataview for the data and a 'false' header structure, usually a custom cube, on top to show customised headings; the custom cube allows me to more easily control the column widths of both objects.
Unless anyone else knows a way, I hope at least I've helped you to know that there is not a simple 'overtype' solution to your question.
thank you for your replay. I think you are right about the defaulted header, which my problem is. I have no entities aligned in column but have references on year (detailed by) and a specific year.
I am not sure what you mean with headerless dataview and "false" header structure as well as custom cube. But I have not tried such things a lot so I might just dont know it yet.
Using References, it is not possible to replace the member title with a custom one. So long as I know how many columns I have 5, 10, [n] and that the number is fixed, I can create a custom entity/cube structure to sit above my dataview. So, if I had 10 fixed columns, I would do this:
1 - [blank]
2 - [blank]
3 - [blank]
10 - [blank]
hide the headers of the fake title dataview.
I think that's the correct sequence - was this any good to you? Again, it is only useful for non-dynamic dataviews where the number of columns remains fixed and the data in them matches the fake title you have set.
Thank you again Paul for your ideas. I have not tried yet to use an individual entity to produce standard headers. But will keep that in mind for further, maybe more standardized, layouts.
Retrieving data ...