Level 100: Screen Design

Walter · 2024-07-27T18:10:27+00:00

There was an error rendering this rich post.

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

Find more posts tagged with

Accepted answers

All comments

Adrien Albrespit

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:

https://help.board.com/v14/docs/rules-basic-concepts

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

Walter

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.
Thanks

Bart Scott

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