Hi, when you log into OneStream using the Excel add-in, your POV is pulled from your Cube POV in the OneStream application. You can check your POV in the OS app here (make sure to log into the same application):
This is then pulled into the Cube POV in Excel:
Please note that if you change your Cube POV in the POV pane in Excel, this will also change your Cube POV in the OneStream application. There is only one Cube POV by user by application.
When you then create a Quick View, the Quick View POV pulls the settings from the Cube POV:
As for how to change the selection in e.g. the consolidation dimension, you can either type in the new member manually, such as "Share"...
...or use the buttons on the right to select another member such as "Elimination"...
...or delete the manual selection which will make it "grey" again:
And this "grey selection" comes from your selection in your Cube POV!
I.e. if you wish to change the selection and leave it "grey", leave the field blank and change the selection in the Cube POV.
That means for you and your colleague(s) that you need to be aware of the Cube POV and align the settings in order to end up with the same POV for your quick views as otherwise you will look at different slices of the data (as you noticed, which led to this post). Or, as always comparing one's Cube POV may not be feasible at all times, ensure that all member selection in the Quick View POV is set in the Quick View itself (i.e. in black) and not driven by the Cube POV (in grey).
I hope this helps!
Any dimensions that are in your Quick View POV that are in grey font (meaning not defined in the Quick View POV) will take from a user POV. If you want to prevent that from happening then any dims in the Quick View POV must appear as shown in green.
There is a subtle difference between picking things in the Quick View POV so they appear as shown in green vs leaving them open to pull from each user's POV as shown in grey font.
Thank you, T_Kress--
Could you please educate me how to change the red-highlighted in the snip below to something else (i.e., cons (USD))? How should I edit USER POV settings?
Thank you in advance for your help. Your support would be greatly appreciated!!!
Eunmi
Hi, when you log into OneStream using the Excel add-in, your POV is pulled from your Cube POV in the OneStream application. You can check your POV in the OS app here (make sure to log into the same application):
This is then pulled into the Cube POV in Excel:
Please note that if you change your Cube POV in the POV pane in Excel, this will also change your Cube POV in the OneStream application. There is only one Cube POV by user by application.
When you then create a Quick View, the Quick View POV pulls the settings from the Cube POV:
As for how to change the selection in e.g. the consolidation dimension, you can either type in the new member manually, such as "Share"...
...or use the buttons on the right to select another member such as "Elimination"...
...or delete the manual selection which will make it "grey" again:
And this "grey selection" comes from your selection in your Cube POV!
I.e. if you wish to change the selection and leave it "grey", leave the field blank and change the selection in the Cube POV.
That means for you and your colleague(s) that you need to be aware of the Cube POV and align the settings in order to end up with the same POV for your quick views as otherwise you will look at different slices of the data (as you noticed, which led to this post). Or, as always comparing one's Cube POV may not be feasible at all times, ensure that all member selection in the Quick View POV is set in the Quick View itself (i.e. in black) and not driven by the Cube POV (in grey).
I hope this helps!
