05-22-2024 08:28 AM
Hi, I'm a new-ish user to OneStream and the QuickViews. Is there a way to prevent a dimension from repeating when you refresh - for example, I want monthly (periodic) columns with a specific UD#7 variable - we will call it A. Then, I want YTD with a different UD#7 member, B for YTD view. Whenever I refresh the QuickView, OneStream will give me both A and B for all periodic and YTD data. Is there a way around this? I don't want YTD with UD#7 member A or Periodic with UD#7 member B but not sure what I need to change for the ad-hoc build.
Thank you!
Solved! Go to Solution.
05-22-2024 09:32 AM
Hello,
To avoid view dimension members from repeating, have the U7# members in column reference view dimension members and leaving view dimension in POV section i.e. within the quick view's column dimension section you will need to use U7#A:V#Periodic, U7#B:V#YTD. With this, you will end up seeing two columns of U7# members one pulling periodic value and other pulling YTD value. Hope that helps!
Thank you
05-22-2024 09:32 AM
Hello,
To avoid view dimension members from repeating, have the U7# members in column reference view dimension members and leaving view dimension in POV section i.e. within the quick view's column dimension section you will need to use U7#A:V#Periodic, U7#B:V#YTD. With this, you will end up seeing two columns of U7# members one pulling periodic value and other pulling YTD value. Hope that helps!
Thank you
05-22-2024 09:41 AM
Thank you! This did work - appreciate your help