Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 8 Next »

Sigma enables you to add an excel sheet template to your reports, to fetch the data based on the dynamic values and formula expressions provided in the excel sheet, with accordance to your needs and requirements.

Let's consider that the following excel sheet template needs to be added to a report. The dynamic values and formula expression provided in the following excel sheet template is based on the data sets available in the demoxl_template table present in the database or schema. It's assumed that a database connection had already been created in Sigma Studio, thereby establishing a connection with the database in which the demo_xl template table is available. Refer Creating a Database Connection for detailed information on creating a database connection in Sigma Studio. 



Let's see how to add an excel sheet template to a report. For adding an excel sheet template to a report, perform the following steps:

  1. Create a data source with the appropriate data element (e.g. demoxl_template), based on which the dynamic values and formula expressions have been specified in the excel sheet.
    1. Proceed to click Save to save the configured data source.

    Ensure that you create the data source using a relevant data element. In the provided example, the demoxl_template DB is the used data element from the database or schema, for which the database connection had already been created in Sigma Studio. For detailed information on creating data sources in Sigma Studio, refer Creating a DB Data Source. 



  2. Create a report with the newly created data source (e.g. EXCEL TEMPLATE DS) and provide the necessary configuration details as per your needs and requirements.
    1. Click the Additional Info tab.



  3. In the Additional Info tab, click the Browse Files option and select the relevant excel template sheet, e.g. Template10.



  4. Once the excel template sheet gets uploaded, click Save to save the report.



  5. Access the report in the Sigma Application and then click Run to generate the report.
    1. Download the generated report in the selected XLS format.



    The fetched data of the downloaded report is displayed in the XLS file, as shown in the following screen shot.

  • No labels

Copyright © Intellect Design Arena Limited.

All rights reserved. These materials are confidential and proprietary to Intellect Design Arena Limited and no part of these materials should be reproduced, published in any form by any means, electronic or mechanical including photocopy or any information storage or retrieval system nor should the materials be disclosed to third parties without the express written authorization of Intellect Design Arena Limited.