Home › Discussions › Questions & Answers › Using Explode to Generate Separate Child Worksheets

Using Explode to Generate Separate Child Worksheets

Avatar photoCustomer Questions & Answers 7 replies

I need to generate a financial report where each child value of a major segment (e.g., Company) appears on its own worksheet. How does the ‘Explode’ feature achieve this?

7 replies

  • Support Enginatics

    The ‘Explode’ feature duplicates the current worksheet for each child value of your segment selection.

  • Avatar photoCustomer

    What types of selections can I make before running ‘Explode’?

  • Support Enginatics

    Your selection can be a Parent segment value, a Segment Value range, a Child segment Value, or any combination of these.

  • Avatar photoCustomer

    What is the final result when I click the Explode button?

  • Support Enginatics

    Blitz FSG retrieves all child values from Oracle and creates a new worksheet for each child value in the current workbook.

  • Avatar photoCustomer

    Does this tool only work if I select a parent segment?

  • Support Enginatics

    No, it works on a variety of selections, including single child segment values or ranges, not just parents.

  • You must be logged in to reply to this post.