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
NicolasArgente's avatar
NicolasArgente
Valued Contributor
4 years ago

umber and a cube datacell number displays side by side. It is like doing a recon between two systems. Has anyone ever done that? I know

Hello!
The cubeview can only check the values in the cube itself. So having in a column a number coming from an outside system will not work. My understanding here, is that the data you need to compare with it outside OS.
Is this number stored anywhere in OS?

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?