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

[Yaseen]

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.

[chul]

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.

[Yaseen]

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.

[chul]

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