Skip to main content
V
Vincent
January 17, 2023
Solved

QuickView Navigate without data

  • January 17, 2023
  • 1 reply
  • 0 views

Hello!

As a EssBase previous user, do you know if it's possible to navigate without data or at least positionning row and colums dimansions without a refresh and once all is done proceed to the refresh.

Because  sometimes when it makes 4 minutes to refresh a cubeview and I have to move at least 5 axis to column or row, it takes 5 x 4 minutes

Thank you in advance. 

    Best answer by db_pdx

    A few options to consider, both of which revolve around limiting the data that is returned while you build your report:

    1) Temporarily set your Entity to E#None.  This way there is no data to retrieve and it will allow you to do your positioning before querying for data

    2) Alternatively, in your QuickView settings, set your 'Maximum Number of Seconds' (query seconds) to 1.  You'll immediately hit the page limit and you'll get control back to continue building your report.

     

    That said, I've never heard of a report taking 4 minutes to refresh.  I'd advise against using QuickViews/CubeViews for doing a datadump (in case that is applicable).  Also, check that you have the appropriate suppression settings turned on.

    1 reply

    D
    db_pdxAnswer
    January 17, 2023

    A few options to consider, both of which revolve around limiting the data that is returned while you build your report:

    1) Temporarily set your Entity to E#None.  This way there is no data to retrieve and it will allow you to do your positioning before querying for data

    2) Alternatively, in your QuickView settings, set your 'Maximum Number of Seconds' (query seconds) to 1.  You'll immediately hit the page limit and you'll get control back to continue building your report.

     

    That said, I've never heard of a report taking 4 minutes to refresh.  I'd advise against using QuickViews/CubeViews for doing a datadump (in case that is applicable).  Also, check that you have the appropriate suppression settings turned on.

    V
    VincentAuthor
    January 17, 2023

    Thanks, you're right both of your solutions works quite fine even if I would have preferred the same option as Essbase.

    And yes I need sometime to retrieve huge amount of datas but the more often refresh are faster!

    M
    MichaelMalandra
    January 19, 2023

    Vincent As mentioned by db_pdx doing a data dump in OneStream is really not a best practice and it defiantly does not work like essbase (I used this feature many times in essbase).  However, understanding why the volume of data is needed is important because excel might not be the only solution available to you.  

     

    Thanks

    Terms & ConditionsAccessibility statement