Level 100: Screen Design
Greetings,
I have three cubes populating data as expected. When I drag these cubes unto my Data view, I get the data, but the arrangement is my problem. I need data from all three cubes to appear something like this.
In my case: EARINGS will be a cube,
OP CASH FLOW my second cube and
NET CASH FLOW my 3rd cube.
Where can I find resources on how to have all three cubes appear on a screen like this?
Thanks
Answers
-
Hi Walter,
Cubes can't be defined as rows, they will always be displayed as columns. In your example, ACT and VS will be cubes and Variance / Variance % will be algorithms based on those cubes.
You can still achieve what you want using rules, please review the manual regarding this feature:
With them, you can calculate on the fly your values for Earnings, OP Cash Flow and Net Cash Flow for all the necessary cubes, creating the logic.
Best regards,
Adrien
0 -
Hello,
@Adrien Albrespit thanks for you response. I have gone over rules, algorithms, data flows, etc. However, I still have a hard time achieving my desired design. I might have mis-phrased my question. Here's is the design I'm trying to realize
Any idea, or link to the right resources will be appreciated.
Thanks0 -
In Layout mode have you tried using Block Alignment of Vertically on the data view?
Then you would need Month on Row (because it should flip that to be the columns, your Blocks would become the rows, and you may need to add Customer to the Column area which also becomes rows, or use detail by Customer). Give that a shot.
Bart Scott
CFO Solutions LLC
0
