Identify hightest/max value of a cube - without time entity

OSchulz

Hi community,

I have a source cube (data type single) with four entities, but no time-entity in it.

I want to identify respective to save the highest value/number of any existing entity combination of the source cube in a target cube, which has only a dummy entity.

I tried it with the "MAX(a)" algorithm as expression, but it gives me the total value instead of the highest.

Is there a way, how I could achieve that in board directly - without using SQL and data readers?

Many thanks in advance and best regards

Akrem ABDELHAFIDH

Hi OSchulz,

For this kind of requirement, you could also try using a Nexel calculation.
NEXEL (Formula Editor) – Spreadsheet-Style Formulas Overlaid on Data Views