Getting data from Stage in Finance Business Rule

Question

Hi there,
thankful for immense contribution from community that has made life easier as a system admin. Currently working on a requirement to query stage data for specific Entity, Account, Scenario, UD1 through UD5 and reseed it back to a intersection that got changed by user input to allow admin to revert any changes done by users. I tried using the below:
&nbsp;
Dim criteria As New Text.StringBuilder
criteria.Append("U1T = '" &amp; ud1_seeded &amp; "' ")
criteria.Append("And U2T = '" &amp; ud2_seeded &amp; "' ")
criteria.Append("And U3T = '" &amp; ud3_seeded &amp; "' ")
criteria.Append("And U4T = '" &amp; ud4_seeded &amp; "' ")
criteria.Append("And U5T = '" &amp; ud5_seeded &amp; "' ")

Dim dValue As Decimal = api.Functions.GetStageBlendNumber("TestCube", "TestEntity", _
    "TestScenario", "2024M1", "TestAccount", BlendCacheLevelTypes.Custom, "Test",  _
    "TestWorkflowProfileName", "U1T,U2T,U3T,U4T,U5T", criteria.ToString, "Amount", _
    BlendNumericOperationTypes.FirstValue)
&nbsp;
doesn't throw a error, but its not getting the amount seeded for&nbsp;TestAccount for the above mentioned workflow profile name. I checked the onestream function documentation, it says the following function documentation:
Dim dValue As Decimal = api.Functions.GetStageBlendNumber(cubeName, entityName, scenarioName, timeName, accountName, cacheLevel, cacheName, wfProfileName, fieldList, criteria, fieldToReturn, mathOperation)
Are my cacheLevel and&nbsp;cacheName correct i set cacheName as "Test" and cacheLevel as&nbsp;BlendCacheLevelTypes.Custom? any other inputs are appreciated

Adam_Bridges · Answer

I'm trying to understand the use case here.. Is the process or issue more complex than removing amounts in O#Forms to restore what was originally loaded?&nbsp; &nbsp; Are user changes being captured outside of the cube initially?

JackLacava · Answer

The caching parameters for GetStageBlend* apis are in the Finance Rules and Calculation Handbook on page 119, but in your case I don't think they're a problem - that cache is created by your call whichever way you want, worst that can happen is that you create an inefficient one, but numbers should still come through. (This said, I'd stick to one of the predefined shapes rather than going for Custom...)
I think the problem for you is more likely to be the Workflow Profile Name, which has to be complete - e.g. "SomeProfile.Import".

JackLacava · Answer

🤷‍ Try using GetStageBlendDataTable instead, which requires fewer parameters, and check what it contains in terms of fields and records.

osdevadmin · Answer

Adam_Bridges&nbsp;thank you for looking in to this! there is some amount that gets seeded initially in&nbsp; TestAccount for O#Import, based on user input in Form in O#Forms, there is business rule that is run that modifies amount for&nbsp;TestAccount for O#Import, but we want to give admins a feature that would restore the original seeded amount for&nbsp;A#TestAccount for O#Import before user made the changes. Currently this process is manual where we have to manually go into stage note down the original amounts and run a dm job, we want to do auto lookup of the amount based on POV that a user would enter in an admin form

osdevadmin · Answer

Thank you&nbsp;JackLacava&nbsp;i corrected the&nbsp;Workflow Profile Name and used&nbsp; BlendCacheLevelTypes.WfProfileScenarioTimeEntityAccount no error, calc took little more time but still getting 0 As result instead of the Amount in the stage.

Forum Discussion

Getting data from Stage in Finance Business Rule

Related Content

Finance Business Rule Data.Calculate format

Finance Business Rule - FinanceFunctionType.FxRate

Finance Functions

Finance Business Rule: Helper Function

Finance Business Rules: Helper Sub