Using Stored Procedures for Creating Reports
- Mahisha Chandrakumar CTOO (Unlicensed)
- Lakshminarayanan1 S CTOO (Unlicensed)
Similar to fetching data from a database table or view for reports, you can also fetch data using the stored procedures in the database. Sigma Studio enables you to create reports by configuring stored procedure for pre-computation. You can also pass parameters to the stored procedure, so that filtration of data can be done based on the passed parameter value(s).
Prerequisites:
- To create a stored procedure datasource, you must have already created a connection in Sigma Studio to the database where the stored procedure is available. Refer Creating a Database Connection for more information on creating a connection.
- It is necessary to create a separate datasource with the table corresponding to the selected stored procedure. Refer Create a DB Data Source for more information on creating a datasource.
Refer the following pages:
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.