Clarity

  • 1.  Hierarchical portlet: Export to excel issue

    Posted Oct 17, 2017 04:56 AM
      |   view attached

    Hi All,

     

    I was facing issue while exporting the hierarchical portlet to excel sheet where Child rows were not getting exported.

    But after going through this thread: https://support.ca.com/us/knowledge-base-articles.TEC530394.html

    I implemented the query as mentioned. Now the child rows are getting exported but some rows are getting missed and some are wrongly grouped.

    Please refer to the attached screenshot for export result.

     

    Can anyone please help what could be the issue?

    Is there any other way to resolve the issue or my implementation 



  • 2.  Re: Hierarchical portlet: Export to excel issue

    Broadcom Employee
    Posted Oct 17, 2017 05:33 AM

    Can you provide some screen shot as well as ppm version



  • 3.  Re: Hierarchical portlet: Export to excel issue

    Posted Oct 17, 2017 07:07 AM

    A possibility for missing rows may be related to handling filters in the NSQL and wrong grouping may be attributed to Sorting order. But again, nothing can be concluded without knowing your NSQL.