Forum Discussion

Russ's avatar
Russ
New Contributor II
2 years ago

Cube selection in Quick View

Is there any way to stipulate the Cube whilst building a Quick View without selecting that Cube on the user's default POV? I've tried typing Cb#CubeName in the cell in Excel but when I create the Quick View it ignores this and uses the default POV Cube. 

In the example I have tried to create QuickView for RETLWRK cube but POV default of MAINREP has been used to I need to change the Quick View cube in the Context Pane after creating the Quick View.

 

 

Excel Add In

3 Replies

Sort By
  • MikeG's avatar
    MikeG
    Contributor III
    2 years ago

     Hi Russ  The Context Pane is that users session POV.  You can't control their session POV.  When the selection is grayed out it means it is not being used in the current view (your screen grab above).  The elipsis and confirming the Cube, upon selection will be bold.

    Hope this helps

     

  • db_pdx's avatar
    db_pdx
    Valued Contributor
    2 years ago

    I think MikeG 's answer is probably what you're after.  But if you are trying to pull the same default intersections across 2 cubes in the one QuickView you can always do overrides (or 'mashups' as we call them).

    For example, if you have account on the row, you can build your member filter as such:

    A#YourAccount:Name(MAINREP),
    A#YourAccount:Cb#RETLWRK:Name(RETLWRK)

     Obviously, this only works if all of the other intersections utilize the same dimensionality.  If you have different dimensionality you can continue to do more mashups by adding ':U1#YourMember' (or any other dimension) as needed so that it properly retrieves data.

  • ckattookaran's avatar
    ckattookaran
    VIP
    2 years ago

    well, if you really truly want it then how about storing that as a template in the user's folder and then ask them to use it as a starting point.