Skip to main content
M
m_b_b_15
May 22, 2024
Solved

Stop repeating dimensions?

  • May 22, 2024
  • 2 replies
  • 0 views

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!

Best answer by 1392

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

2 replies

1
1392Answer
May 22, 2024

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

M
m_b_b_15Author
May 22, 2024

Thank you! This did work - appreciate your help

Terms & ConditionsAccessibility statement