Planning Analytics

Planning Analytics

Get AI-infused integrated business planning

 View Only
Expand all | Collapse all

PAW issues around exporting and importing data and elements

  • 1.  PAW issues around exporting and importing data and elements

    Posted Wed February 26, 2025 04:27 AM

    Hello,

    Over the past several weeks and months, I had several interactions with IBM support on issues around exporting and importing data and elements, all in PAW.

    Meaning that, an export does not happen, or it gives a CSV file with only the header line (dimension names). Or the export takes place but the import of that same file in the same cube on development does not finish. Sometimes the data is prepared but the file is not downloaded. Etc.

    This topic is just to let you know that a number of these tickets lead to known defects and IBM are correcting them. First have a look at known defects before spending too much time or creating new support tickets.



    ------------------------------
    Wim Gielis
    Senior Consultant
    Aexis International
    Sint-Stevens-Woluwe
    0496225001
    ------------------------------


  • 2.  RE: PAW issues around exporting and importing data and elements

    Posted Fri February 28, 2025 08:07 AM

    Hi Wim,

    The CSV export feature that we added is generating an MDX query and pushing the results of that query to a file.  One possible reason why a valid MDX query might fail is the MaximumViewSize parameter in TM1 being set too low.  We are working on some improvements to detect when the query failed and properly indicate the failure to the user.

    We are still working on functionality in PAW books that will allow action buttons to be used to run a TI process and download the results.  The significant difference between using MDX and TI processes to export is model security (TI processes ignore security). 



    ------------------------------
    Stuart King
    Product Manager
    IBM Planning Analytics
    ------------------------------