Skip to main content
fellow_Ones
Member
Nov 16, 2023 9:17 PM UTC

Capture values from cube view and create a list to use in Business rule, For loop.

Hi -

I want capture data cell values from two columns of the cube view and save them as a list and used the list to loop through the calculations. i would appreciate help with a sample code or guidance.

Thanks.

YM.

3 replies

Employee - Guide
chulEmployee - Guide
Employee - Guide
Nov 17, 2023 3:46 PM UTC

It would be best to use api.data.calculate or pull a data buffer of the values that you need rather than creating a list and looping through it.

    fellow_OnesAuthor
    Member
    Nov 17, 2023 8:16 PM UTC

    I need the values out of cube view selection to use in the business rule in api.data.calculate. Need is to capture and save the values before applying in the calculations. Idea is to use dictionary to add "mCostCenter As MemberInfo In listCCs" to dictionary and loop thru the list in the dictionary to reduce BR processing time. 

    Appreciate sample code to add memberinfo to the dictionary.

    Employee - Guide
    chulEmployee - Guide
    Employee - Guide
    Nov 20, 2023 8:39 PM UTC

    9:45 in this presentation: https://community.onestreamsoftware.com/t5/WAVE-Content/Using-Business-Rules-for-Data-and-non-data-Activities/ta-p/25852

    Terms & ConditionsAccessibility statement