Max Value

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
    Fourth Anniversary 250 Likes 100 Comments 5 Answers
    edited March 2020

    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
    Second Anniversary First Comment

    Thank you!

    I'll try as you suggest!