Planning Analytics

 View Only

  • 1.  PAW unable to export Workbook

    Posted Tue April 04, 2023 06:42 AM

    Hi there

    PAW is unable to export a workbook with 27 tabs. The workbook contains mostly grid-type reports with limited graphs and images. PAW version is 83.

    Error in tm1web logs:
    [err]     at com.ibm.cognos.tm1.websheet.calculation.formulaparser.PtgFunc.EvaluateArgs(PtgFunc.java:259)
    [err]     at com.ibm.cognos.tm1.websheet.calculation.formulaparser.PtgFunc.validateArgs(PtgFunc.java:493)
    [err]     at com.ibm.cognos.tm1.websheet.calculation.formulaparser.PtgFunc.evaluate(PtgFunc.java:448)
    [err]     at com.ibm.cognos.tm1.websheet.calculation.formulaparser.WebFormula.evaluate(WebFormula.java:427)
    [err]     at com.ibm.cognos.tm1.websheet.SheetCell.evaluate(SheetCell.java:855)
    [err]     at com.ibm.cognos.tm1.websheet.calculation.formulaparser.PtgRef.evaluate(PtgRef.java:280)
    [err]     at com.ibm.cognos.tm1.websheet.calculation.formulaparser.PtgFunc.EvaluateArgs(PtgFunc.java:408)
    [err]     at com.ibm.cognos.tm1.websheet.calculation.formulaparser.PtgFunc.validateArgs(PtgFunc.java:493)
    [err]     at com.ibm.cognos.tm1.websheet.calculation.formulaparser.PtgFunc.evaluate(PtgFunc.java:448)
    [err]     at com.ibm.cognos.tm1.websheet.calculation.formulaparser.WebFormula.evaluate(WebFormula.java:427)
    [err]     at com.ibm.cognos.tm1.websheet.SheetCell.evaluate(SheetCell.java:855)

    We have updated the cell counts to 10 000 000 and workbook tab count to 50, still, we are unable to export. Smaller workbooks with 17 tabs export fine.

    Has anyone come across a similar error?



    ------------------------------
    Francois Kritzinger
    ------------------------------


  • 2.  RE: PAW unable to export Workbook

    Posted Tue April 04, 2023 09:36 AM
    Edited by Svetlana Pestsova Tue April 04, 2023 09:49 AM

    Hi Francois,
    It would be better to log a support case to fully investigate your scenario.

    Btw, the way to aproximately estimate the transfer size of the book would be to check the network tab. The images could contribute a good number towards the size, so you may consider to be lighter on the image usage.

    ------------------------------
    Svetlana Pestsova
    IBM Planning Analytics Product Manager
    ------------------------------

    Original Message


  • 3.  RE: PAW unable to export Workbook

    IBM Champion
    Posted Wed April 05, 2023 12:58 AM

    Hi Francois

    When I try to export a book using Chrome, nothing happens at all, however, if I use Edge on the same book, it works fine.
    Have you tried with a different browser ?

    Cheers



    ------------------------------
    Armand Mizan
    Business Analytics Solutions Specialist
    ------------------------------

    Original Message


  • 4.  RE: PAW unable to export Workbook

    Posted Wed April 05, 2023 03:11 AM

    Hi everyone,

    We resolved the issue. It ended up being a hidden sheet that gave a circular references error in all of the DBRWs when we unhid the sheet and publish. This caused the workbook to break. We fixed this report and published it again. 

    Exporting on Firefox, Edge, and Chrome is working fine now.

    Regards



    ------------------------------
    Francois Kritzinger
    ------------------------------

    Original Message