Hi Jacky,
You can use row overrides in your column, in my example I have used two different accounts (you can have up to four using the overrides):
I hope it helps.
Hi - thanks for your suggestion and demonstration. It works perfectly when there is only one account used in the cube view. I am able to produce several reports with your method. Thanks a lot for the help.
But if we have a report with multiple accounts (e.g., all expense accounts breakdown by cost centers), I cannot set the accounts in cube view POV. I wonder is there another approach for this scenario?
Also, is it possible to have some rows display in cost centers while some rows display in product dimension? Thank you so much for the help.
Best,
Jacky
There might be ways to hack around using Overrides, but I don't have enough experience with those to suggest a solution.
For more complex layouts, you will have to look into using the Dashboard Report Component, which can produce "pixel perfect" reports in arbitrary format (might take a bit to master, although you can start from existing reports and tweak them), or Cube View Extenders, which allow you to lay out the report more or less any way you want (but with VB.Net programming).
I see, thanks a lot. I am looking for situation that minimize the coding effort, so it would great if there is some examples of using override to produce the report layout.
Hi Jacky,
You can use row overrides in your column, in my example I have used two different accounts (you can have up to four using the overrides):
I hope it helps.
Hi - thanks for your response and example, it will definitely help me with the report layout development. I just have one follow up question, may I know what the substitution variable is used so that the header is renamed as the overridden account (e.g., Employee Compensation and Sales in your screenshots).
Thank you so much.
Jacky
