Announcing a new experience for the Oracle Analytics community coming April 4th!
This category will be read-only as we migrate this space from 3/30-4/4, after which you’ll be able to post as usual. See you there!
How to trigger SmartView business rule via VBA
Content
My apologies if I am not posting this in the correct forum. The Smartview Forum had a message that it moved and the link took me here. If it's not correct here, kindly send me to the right spot. Thank you!
I am fairly new to utilizing VBA in conjunction with Smartview and have a project that I'm not 100% sure how to do. The goal is to write a macro that submits the data of an adhoc worksheet to Hyperion, runs a User Calculation called "Forecast Task" and then refresh another worksheet.
I'm good with submit and refresh, but not sure about how to trigger the business rule. I looked at the Developer Guide that addresses VBA and believe that HypExecuteCalcScript might be the way. However, the business rule that I need to run requires the entity dimension to be defined. I did not see any mention in the developer guide on how to do that when running HypExecuteCalcScript. I only know how to execute it through the Smartview Panel. I attached a screenshot of the task that i need to execute.