Forum Discussion

Yaseen's avatar
Yaseen
New Contributor III
2 years ago

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 guid...
Finance
Yaseen's avatar
Yaseen
New Contributor III
2 years ago

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.