Max Value

Options
Emanuela Dolce
Emanuela Dolce Active Partner
First Comment First Anniversary
in Platform

Hello!

Is it possible to compute the max value of a cube on a not-time entity?

I need to memorize this value inside another cube.

Does anyone have any suggestions?

Thank you!

Answers

  • Alexander Kappes
    Alexander Kappes Employee
    First Anniversary Level 100: Foundations of Building in Board Level 200: Leveraging Board for Business Insights Name Dropper
    edited March 2020
    Options

    Dear Emanuela Dolce,

     

    this is only possible using procedure and Export Layout Procedure Step.

     

    This step allows you to define your extract file according to a DataView.

     

    Means you have to define the row Entity, which should be the one where you Need the biggest value of.

     

    image

    Finally you filter your cube for the biggest value.

     

    The extracted File can be reloaded into another cube e.g. by using ASCII Reader.

     

    But using this Suggestion you have to take care, that you extract a file according to one Dimension. When you Need other structure in your target cube you have to build up process to implement the figure into this.

     

    Depending to the Detail case perhaps nexel can also be working solution for your

     

    regards

     

    Alexander Kappes

  • Emanuela Dolce
    Emanuela Dolce Active Partner
    First Comment First Anniversary
    Options

    Thank you!

    I'll try as you suggest!

Categories