Save calculations in entity

Hello,

 

In a DataView I have a block that contains calculations on entities and cubes. I want to store the Totals of this calculated block in an entity.  How do I do that?

 

Best regards,

Steven

Answers

  • Björn Reuber
    Björn Reuber Employee, Community Captain
    500 Likes Fourth Anniversary 100 Comments 5 Answers

    Hi,

     

    the simplest way would be to extract this layout to disk (Procedure Step) and use a DataReader to load the data to an entity.

    Otherwise #Nexel would be also an option

     

    Regards

    Björn

  • ok thanks Björn.  How would I capture the total with #Nexel?

  • Björn Reuber
    Björn Reuber Employee, Community Captain
    500 Likes Fourth Anniversary 100 Comments 5 Answers
    edited March 2020

    Hi Steve ,

     

    you can directly choose it within the Range

    image

    image

     

    Regards

    Björn

  • Hi Bjorn,

     Using nexel we calculated the total but again if we need to store that total to an entity, we have to write procedure and using data reader we need to load that value to the entity right?

  • Björn Reuber
    Björn Reuber Employee, Community Captain
    500 Likes Fourth Anniversary 100 Comments 5 Answers

    Hi Niharika,

     

    no, you can also write directly into an entiy/cube.

     

    We have a simple example in our Manual: Nexel using the write implace option.

     

    Regards

    Björn