Forum Discussion

m_b_b_15's avatar
m_b_b_15
New Contributor II
8 months ago

Stop repeating dimensions?

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 va...
Excel Add In
  • 1392's avatar
    1392
    8 months ago

    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

1392's avatar
1392
New Contributor II
8 months ago

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