11-24-2023 06:10 AM - last edited on 11-27-2023 10:27 AM by JackLacava
Would like to check if Quick View in excel can extract/pull - Annotations/Audit Comments/Variance Explanations from "View" dimension.
Please assist. Thank you.
Solved! Go to Solution.
11-30-2023 06:04 AM
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:
11-30-2023 08:23 AM
Hi Mark,
The row suppression settings on quick view worked.. 😀
Thank you very much..!
11-24-2023 06:28 AM
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
11-24-2023 06:42 AM
Yes, we did select the relevant view member "Variance Explanation"
We pull the numbers but not variance explanation.
11-27-2023 10:27 AM
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.
11-29-2023 08:39 AM
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.
11-29-2023 10:27 AM
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
11-30-2023 05:55 AM
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?
11-30-2023 06:04 AM
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:
11-30-2023 08:23 AM
Hi Mark,
The row suppression settings on quick view worked.. 😀
Thank you very much..!