Forum Discussion

Sergey's avatar
Sergey
Contributor III
9 months ago

Load data to the cube, with a business rule, without transformation and validation

Dear Community, For an allocation purpose, I would like to load data currently stored in a data table, into a cube. But to speed up the process, I would like to ignore Validation and Transformation...
Extenders
Finance
  • ChristianW's avatar
    ChristianW
    9 months ago

    You can launch a custom business rule to load from a datatable or a csv file using a calculation.

    • Query the table or load a file (you will find samples in the snippets)
    • Loop the rows/lines
    • Identify the pov
    • Use a calculation API.data.calculate($“{pov} = {amount}“,…,True)

    The true is for the stickiness of the calculation and is required to let the data survive the next calc or consolidation.

ChristianW's avatar
ChristianW
Valued Contributor
9 months ago

You can launch a custom business rule to load from a datatable or a csv file using a calculation.

  • Query the table or load a file (you will find samples in the snippets)
  • Loop the rows/lines
  • Identify the pov
  • Use a calculation API.data.calculate($“{pov} = {amount}“,…,True)

The true is for the stickiness of the calculation and is required to let the data survive the next calc or consolidation.