Quick View - Annotations/Audit Comments/Variance Explanations

[Pradnya]

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

Please assist. Thank you.

[MarkBird · Accepted solution]

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:

[MarkBird]

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]

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

We pull the numbers but not variance explanation.

[JackLacava]

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]

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]

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]

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 · Accepted solution]

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 · Accepted solution]

Hi Mark,

The row suppression settings on quick view worked.. 😀

Thank you very much..!