Bex query on CO-PA cube with calendar days in rows

[ivan_blatnik2]

Hello,

I have a requirement to build query showing all calendar days in rows. Columns should show value depending on the date:

- if Entry date = calendar date in column Entry order value

- if Required date = calendar date in column Required order value

etc

This are lines in my cube

...and this is how the report should look like:

I appreciate your answer!

Ivan

[Former Member]

Hi Ivan, I would create 2 calculated KFs to be as columns ( entry order value, required order value etc.) Use count function to define the condition along with the order value. i.e. count( entry date == 0calday)*entry order value. You will need to create a variable with replacement path for entry date ( Characteristic value = Entry Date, info object as key, dimension = date ) Give it a go, its fun! Kind regards Las