Versions Compared

Version Old Version 4 New Version Current
Changes made by

DevaDarshini.S

DevaDarshini.S

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Expand
titleI want some SQL statements to be executed before a report is generated to prepare the data for the report. Is this possible in Sigma?

Yes, you can execute stored procedures as pre-hooks before a report is generated. Refer Using Stored Procedure as pre-hook for Creating Reports for more details.

Data Composer (Multiple/ Aggregated Data Sources)

Expand
titleCan I create/ use an aggregated data source joining data from multiple data bases or sources, for my report?

Yes, you can use the data builder feature to create an aggregated data source, connecting data from multiple sources (irrespective of their data root sources). Refer to Join Types in DataBuilder for more information.However, the data will be processed in application memory. Hence, sufficient care to be taken while creating the data aggregator.

...