How to change the header of a dataview between forecast and actuals
Julian Boelsen
Active Partner
Hello everyone,
I am building right now a 3+9, 6+6,... forecast and I want to change the header of the dataview accordingly to forecast and actuals (e.g. 3+9 forecast first 3 months actual, last 9 months forecast). The cube can be the forecast cube for both actuals and forecast. It is just necessary to display the header correctly. Is it possible to do this in one dataview?
I've got a lock cube for the data entry that is 0 to enter some digits for the forecast.
Thank you!
Cheers,
Julian
------------------------------
Julian Boelsen
Consultant
better decisions GmbH
Germany
------------------------------
I am building right now a 3+9, 6+6,... forecast and I want to change the header of the dataview accordingly to forecast and actuals (e.g. 3+9 forecast first 3 months actual, last 9 months forecast). The cube can be the forecast cube for both actuals and forecast. It is just necessary to display the header correctly. Is it possible to do this in one dataview?
I've got a lock cube for the data entry that is 0 to enter some digits for the forecast.
Thank you!
Cheers,
Julian
------------------------------
Julian Boelsen
Consultant
better decisions GmbH
Germany
------------------------------
0
Answers
-
Dear @Julian Boelsen,
the header being displayed depends on the block you are using. If all your columns refer to the same cube the columns' header will display the cube's name (or the block's heading respectively).
So, you'd need different blocks to display different header information. From my point of view, it would be best to use a "detail by" (Month) option and references.
Let me know if you need further assistance.
Kind Regards,
Helmut
------------------------------
Helmut Heimann
Senior Consultant
Board Community
Germany
------------------------------
-------------------------------------------0