You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Invoke a business rule for an array?

Question
2
Views
0
Comments
edited Aug 2, 2018 2:36AM in Essbase

Summary

Invoke a business rule for an array?

Content

Hi,

PBCS

in the same way that you can invoke a business rule from a form and have a business rule that launches on save which uses the values in the form, is it possible to do the same from an ad-hoc grid in Smart View, but responding to an array of values?

i.e.

Business Rule

Fix ({CostCentreArray},{EntityArray})

Excel;

CostCentreArray =  A5:A(last populated value in spreadsheet)

Entity= B5:B(last populated value in spreadsheet)

The only way I can think of is to invoke this in a loop via Visual Basic in excel, calling the script for each row, but is massively sub-optimal, so I wonder if there was anyway better?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!