Forum Discussion

RonnieKarpinsk's avatar
RonnieKarpinsk
New Contributor III
2 years ago

Excel Cube Views POV Changes

Hello,

How can I change the POV for a Cube View I open in Excel? Is this possible? 

Regards,

Ronnie Karpinski

  • Hello Ronnie, are you opening it in Excel from the Cube View page or have you created a Cube View Connection? If you create a Cube View Connection and leave the default (Cube) POV, you will be able the change the POV selection.

  • RobbSalzmann's avatar
    RobbSalzmann
    Valued Contributor II

    One way is to configure the CV to use Input or Member Selection Parameters for aspects of the POV you want the user to have control over.  The user will be prompted to keep/change the member(s) used when the CV is launched or refreshed.

  • Noemi's avatar
    Noemi
    New Contributor III

    Hello Ronnie, are you opening it in Excel from the Cube View page or have you created a Cube View Connection? If you create a Cube View Connection and leave the default (Cube) POV, you will be able the change the POV selection.

  • RonnieKarpinsk's avatar
    RonnieKarpinsk
    New Contributor III

    I finally figured it out. You just have to hit the refresh sheet button. Not sure why I never tried that. Thanks!