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

Smart view VBA Rule Execution

in Planning

Hello All,

I wanted to share a solution that may help anyone trying to execute a Planning/Groovy Business Rule directly from Excel Smart View VBA.

Most examples online suggest using the REST API, but that requires another authentication (or storing credentials). If your users are already authenticated through Smart View, you can execute the business rule using the existing Smart View session by calling HypExecuteCalcScriptEx.

This avoids:

  • Storing administrator credentials
  • Prompting users for a second login
  • Calling the REST API

The business rule executes under the same Smart View session that the user is already connected with.

Below is a simplified example for a Groovy business rule named

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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