Skip to main content
F
fellow_Ones
November 16, 2023

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

  • November 16, 2023
  • 3 replies
  • 0 views

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

C
chul
November 17, 2023

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.

F
fellow_OnesAuthor
November 17, 2023

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.

Terms & ConditionsAccessibility statement