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

[Ashok]

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. Has anyone ever done that? I know I can do it in a dashboard using dashboard extender BR and display in a pdf report but I need to capture some comments from the user and store it in the cube that’s why trying to see if a member formula can do it so that it can be used in a cube view report. Are there any example anywhere in golfstream app to reference? appreciate any help.

[NicolasArgente]

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]

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]

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

[ckattookaran]

That is relational blending, I did write a few blog posts on the same. You can create members in the cube that will get the values from external sources.