The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

Pradnya's avatar
Pradnya
New Contributor II
2 years ago
Solved

Quick View - Annotations/Audit Comments/Variance Explanations

Would like to check if Quick View in excel can extract/pull - Annotations/Audit Comments/Variance Explanations from "View" dimension.

Please assist. Thank you.

  • Pradnya,

    A couple of questions:

     - Are you sure that you have data for the intersection that you are looking at?

     - Have you managed to view this data in a Cube View?

    It might be helpful for you to change the row suppression settings on your cube view:

     

  • Pradnya's avatar
    Pradnya
    2 years ago

    Hi Mark,

    The row suppression settings on quick view worked.. ðŸ˜€

    Thank you very much..!

8 Replies

  • MarkBird's avatar
    MarkBird
    Contributor III

    Hi Pradnya

    Just select the relevant view member:

    Are you having any issues pulling this information into your Quick View? If so, send some screenshots.

    Regards,

    Mark

     

    • Pradnya's avatar
      Pradnya
      New Contributor II

      Yes, we did select the relevant view member "Variance Explanation"

      We pull the numbers but not variance explanation.

  • JackLacava's avatar
    JackLacava
    Icon for OneStream Employee rankOneStream Employee

    Just switching to the right view should work; if it doesn't, there might be a regression and you might want to talk to Support about it.

    • Pradnya's avatar
      Pradnya
      New Contributor II

      Can you please elaborate when you say "Just switching to the right view should work"?
      In View dimension we have "Variance Explanation", where user report/input variance explanation as text.

      • MarkBird's avatar
        MarkBird
        Contributor III

        Hi Pradnya

        Can you try moving the View filter to the columns then add both 'YTD' and 'VarianceExplanation'.

        Send us a screenshot so that we can see the output.

        Regards,

        Mark