Skip to main content
MZ7
Newcomer
Nov 3, 2023 3:21 PM UTC

Calling Excel Function from Business Rules

Anyone has called and executed Excel function (Forecast.ETS) from within a business rule?

2 replies

Employee - Sage
JackLacavaEmployee - Sage
Employee - Sage
Nov 7, 2023 7:28 AM UTC

You would need to install Excel on the server, and then access its COM libraries - which can be tricky to get right, are very slow, and have significant issues in terms of resource lifecycle. I would not recommend doing that from OneStream, even if possible.

    MZ7Author
    Newcomer
    Nov 7, 2023 2:14 PM UTC

    Thanks JL! I had a feeling that it is possible but costly in terms of coding and data processing. We will let them prepare data outside OneStream before load in for now. There needs a discussion here to find an alternative forecast modeling approach to replace the Excel Forecast.ETS.

    Terms & ConditionsAccessibility statement