Forum Discussion

Pradnya's avatar
Pradnya
New Contributor II
2 years ago

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.
annotations
Excel Add In
  • MarkBird's avatar
    MarkBird
    2 years ago

    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..!

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

Pradnya's avatar
Pradnya
New Contributor II
2 years ago

Thank you Mark.. we tried moving the View filter to the columns and added "YTD" & "VarianceExplanation", it did not work. Showing below result

 

Am i missing anything?

  • MarkBird's avatar
    MarkBird
    Contributor III
    2 years ago

    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
      New Contributor II
      2 years ago

      Hi Mark,

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

      Thank you very much..!