Forum Discussion

matthewsb419's avatar
matthewsb419
New Contributor
16 hours ago

V#VarianceExplanation - Best Ways to Use

Hi,

I'm trying to understand the best way to add annotations and comments in OneStream to explain variances.

Last week at splash I was advised to use V#Annotation or V#VarianceExplanation.  But what I'm confused about is how do you actually get it connected to the calculated variance (red box), versus only being able to connect it so the actual reported number (yellow box).  Right now I'm using a get data formula in my quick view to calculate the variance (GetDataCell(S#Actual-S#AOP):Name(Variance)).

What are other people doing when trying to provide commentary on variances?  Whats the best way to use this view?

 

annotations
Reports

1 Reply

Sort By
  • BenEppel's avatar
    BenEppel
    New Contributor III
    14 hours ago

    You can not have any annotations or other text based view members within a GetDataCell. The explanation needs valid members for each dimension. You could use V#Annotation for any comments related to the forecast amount and then V#VarianceExplanation for comments related to that scenario vs Actual. On the View member filter you can add a custom name like this V#VarianceExplanation:Name(Actuals vs AOP).