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. 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.

Reports

4 Replies

Sort By
  • 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.
  • ckattookaran's avatar
    ckattookaran
    VIP
    4 years ago

    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.