ContributionsMost RecentMost LikesSolutionsRe: How to place multiple UD1 members in Account dimension UD1 constraint KarlTThank you for your reply. But I have many accounts and Products combination. It is quite difficult to create alternate constraint hierarchy. How to place multiple UD1 members in Account dimension UD1 constraint Hello OneStream experts: Thank you for the helps in the past. I have a quick question about placeUD1 members in Account dimension UD1 constraint For example: In my account metadata dimension: I ...Re: Can MultiplyUnbalanced function take more than 2 components JackLacava: Both of your suggestions are very helpful. Thanks a million! Can MultiplyUnbalanced function take more than 2 components Hello OneStream experts: Thank you for the helps in the past. I found this forum is very helpful. I feel theMultiplyUnbalanced function is very nice and wonder if it can take more than 2 compon...SolvedRe: The Consolidate button is always greyed out in my excel quick view T_KressThank you so much for the information. It answered my question. The Consolidate button is always greyed out in my excel quick view Hello OneStream experts: Thank all of you for the dedicate helps. I build onestream quick view using excel. It seems all the functions in my quick view is working except the consolidate button is a...SolvedRe: How to use if statement to check calculation flag Henning Thank you for the reply. I do have many flags. Each Country member has a flag and I may have many countries. I think I need to create a data buffer for the Flag and loop through the buffer. Re: How to use if statement to check calculation flag FredLucas:Thank you so much for you advice. I will try this approach. Re: How to use if statement to check calculation flag I try the following Dim FlagDataCell As DataCell =api.Data.GetDataCell("A#Rebate_Flag:UD1#No_Product:UD2#All_Country") If ((Not FlagDataCell Is Nothing) And (Not FlagDataCell.CellStatus.IsNoData...Re: How to use if statement to check calculation flag FredLucas: Thank you so much for your reply. Looks likewe indeed need the flag to be stored as data and I need to look into using GetDataCell to retrieve the flag and do the calc for that data unit...