How can I transform this formula into dataflow procedure?

Hi all,

I have this excel formula like this one :

INDEX Price from KSB1; MATCH By Cost Center and By PN Material Consumed

MAXIFS(By Period; By Cost Center; By PN Material Consumed; Period Between Actual From and Actual To)

So how can I achieve this value by using dataflow procedure? and how it should be of my cube dimension to achieve this goal?

Thanks

Find more posts tagged with

Dataflow

Accepted answers

Ilham Maulana Habibie

Hi @Hamza Mesbahi

Thanks for your response, but I have solved this issues anyway.

Thank you

All comments

Hamza Mesbahi

Hi @Ilham Maulana Habibie,

Thanks for your question. Just to clarify, are you trying to extract the maximum price of a material for a specific cost center across a defined time period? What are the dimensions of the cube holding this data in Board (that you want to extract the MAX value from)?

Have you considered using the "MAX Value" Analytical Function? This is a data block function in Board that enables you to extract the maximum value from a time-dimensioned source cube over selected periods and flows it into your target cube.

For example, if your procedure has the year 2025 selected, and your source cube is dimensioned by Month, Cost Center, and Material, applying that function would extract the highest value for each cost center/material combination across the selected months.

You can find more details on analytical functions here: https://help.board.com/v14/docs/about-data-block-settings#analytical-functions

Let me know if this helps, or if I misunderstood your use case.

Kind regards,

Hamza

Ilham Maulana Habibie

Hi @Hamza Mesbahi

Thanks for your response, but I have solved this issues anyway.

Thank you

Hamza Mesbahi

Thanks @Ilham Maulana Habibie, glad it was resolved!