Quick View - Annotations/Audit Comments/Variance Explanations

Pradnya
New Contributor II

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

Please assist. Thank you.

2 ACCEPTED SOLUTIONS

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_0-1701342227874.png

 

View solution in original post

Pradnya
New Contributor II

Hi Mark,

The row suppression settings on quick view worked.. 😀

Pradnya_0-1701350603860.png

Thank you very much..!

View solution in original post

8 REPLIES 8

MarkBird
Contributor III

Hi Pradnya

Just select the relevant view member:

MarkBird_0-1700825256397.png

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

Regards,

Mark

 

Pradnya
New Contributor II

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

Pradnya_0-1700826104006.png

We pull the numbers but not variance explanation.

JackLacava
Honored Contributor

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

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
New Contributor II

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

 

Pradnya_1-1701341701352.png

Am i missing anything?

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_0-1701342227874.png

 

Pradnya
New Contributor II

Hi Mark,

The row suppression settings on quick view worked.. 😀

Pradnya_0-1701350603860.png

Thank you very much..!