Essbase

Get Involved. Join the Conversation.

Topic

    Dhamu Chinnavelusamy
    Unable to Cascade smartview ad-hoc report/sheet - Essbase
    Topic posted August 30, 2018 by Dhamu Chinnavelusamy, last edited August 30, 2018, tagged Essbase, Smart View 
    226 Views, 3 Comments
    Title:
    Unable to Cascade smartview ad-hoc report/sheet - Essbase
    Summary:
    Unable to Cascade smartview ad-hoc report/sheet - Essbase
    Content:

    Hi, 

    I have created smartview ad-hoc template/report connecting Essbase - OAAC.  When I am trying to cascade the same, I am getting error "Sheet needs refresh. Refresh the sheet before performing cascading" even after the sheet is refreshed. Note that cascading works fine while ad-hoc or recreatiing the report/template.

     

    Thanks,

    Dhamu

    Image:

    Comment

     

    • Mike Larimer

      You said that cascade works except for this one instance it is asking you to refresh and then still does not work.  I would logout/login and try again.

    • Glenn Schwartzberg

      are you using an ad-hoc or does it use hsgetvalue formulas? If the latter, I do not believe cascade is supported

      • Dhamu Chinnavelusamy

        Hi Glenn, I cant cascade because the sheet has calculation values reference from another sheet. 

        So I removed those references and tried cascading. It worked. Thanks for your support.