Forum Discussion

Ashok's avatar
Ashok
New Contributor III
4 years ago

Can a member formula fetch a number from an external table to display in a cubeview report

Hello All, I have requirement to present a number from an external table in cubeview so that number and a cube datacell number displays side by side. It is like doing a recon between two systems. H...
Reports
Ashok's avatar
Ashok
New Contributor III
4 years ago

Thanks for reply @nicolas.argente. I found a way to do it. example is RCM_FormulaHelper finance business rule. Basically,

  1. Define the public function in dashboard extender - this will return a decimal value
  2. In Finance business rule link this via properties of BR by enabling the “Contains Global Functions or Formula” property to true and also put the BR in the reference assemblies.
  3. call this Finance BR function from the Member formula set as dynamic calc.
NicolasArgente's avatar
NicolasArgente
Valued Contributor
4 years ago

Good to hear Ashok! Where was your original number stored?