i have a entity called "Test" members of its entity are Test1, Test2, Test3, Test4
Now i need to do a calculation such that Test1+Test2-Test3 and store this value against Test4.
can you please help me in this.
Thank you for support
Hi Vanam, you're talking about a Rule, if you read this article it will explain how to create the rule for the calculation you describe, you can then use a data flow to write the calculated values to a cube. https://help.board.com/docs/rules-basic-concepts
Hi @Robert Barkaway, Thank you for responding
I agree we can achieve this with the help of rule but that makes on the fly value but we need to load the data against the test4 member so that we can display the value in other screens
Hi Vanam, no you can write rule values back to a cube as well, you just need a dataflow with block a being the source cube with the rule applied and block b being the cube you want to write the values back to including the rule calculations, then b=a
Thanks a lot @Robert Barkaway.
It worked. Thank you for your support.
