Class FormulaService Fusion Embed

Service for working with shared formulas.

Constructors

constructor

new FormulaService(sisenseContextService): FormulaService

Parameters

Parameter	Type
`sisenseContextService`	`SisenseContextService`

Returns

FormulaService

Methods

getSharedFormula

getSharedFormula(params): Promise< CalculatedMeasure | null >

Fetch a shared formula from a Fusion instance.

The formula can be identified either by oid or by name and dataSource pair.

When the retrieval is successful but the shared formula is not found, the result is null. When the retrieval is not successful, the promise is rejected with an error.

Example

Retrieve a shared formula by oid:

try {
  const formula = await formulaService.getSharedFormula({
    oid: 'd61c337b-fabc-4e9e-b4cc-a30116857153',
  });

  if (formula) {
    console.log('Formula found:', formula);
  } else {
    console.log('Formula not found');
  }
} catch (error) {
  console.error('Error:', error);
}

Example

Retrieve a shared formula by name and data source:

try {
  const formula = await formulaService.getSharedFormula({
    name: 'My Shared Formula',
    dataSource: DM.DataSource,
  });

  if (formula) {
    console.log('Formula found:', formula);
  } else {
    console.log('Formula not found');
  }
} catch (error) {
  console.error('Error:', error);
}

Parameters

Parameter	Type	Description
`params`	`GetSharedFormulaParams`	Parameters for retrieving the shared formula. Must include either `oid` or both `name` and `dataSource`.

Returns

Promise< CalculatedMeasure | null >

Promise that resolves to the shared formula, or null if not found