(2208) Step 2. Impact analysis

Owned by SNP
Last updated: Aug 09, 2022 by Marian Vidra
3 min read

Impact analysis for the objects using the SDA+ interface finds dependent objects such as MultiProviders or CompositeProviders, Lookups, Stragglers, and DTPs for the selected DataProvider. Detailed information about Impact analysis can be found in the chapter (2208) Object Translation.

  1. To start the analysis, proceed with the Wizard, or on the main screen select specific DataProviders from the context menu and choose Impact Analysis.
  2. Click Execute analysis and then Refresh.
    The Impact analysis is executed on all DataProviders, which are present in the DataProvider name column. If you want to analyze only one DataProvider, select a particular row.

After execution of the analysis, all found dependent objects are displayed (Lookups, MultiProviders, or CompositeProviders, Stragglers, DTPs). With a click on Switch object status you may switch the status of the dependent objects among:

  • Not adjusted - Dependent object which isn't adjusted (reading offloaded data is not possible in this stage)
  • Adjusted - All Dependent objects are adjusted and DataProvider is ready to read offloaded data
  • Ignored - Dependent object is ignored and will not be adjusted


On Reporting tab, the user can display all the queries above the Composite or MultiProvider, click on the button Queries at the end of the row with the specific MultiProvider. Information about the query for the particular InfoProvider appears, or a message informs you that the InfoProvider doesn't contain any queries.

Transitive navigation attributes are not supported.

In a column of Transitive navigational attributes, the user can see if the InfoProvider contains any or not. It is not allowed to add Transitive navigational attributes to the Cube, therefore it will be not added to the generated Virtual Provider. VirtualProvider can be included in the CompositeProvider but TNA needs to be turned off from CP`s output in order to successfully reactivate CP (manually). Any query built on top of such CP with turned off TNA and the query columns mapped to turned off TNA - will be NOT executable. Click on the button TNA will display the list of InfoObjects and their transitive navigational attributes.


Impact analysis for the objects using the DTO interface finds queries for selected DataProvider and dependent CompositeProviders. Click on Switch object status to (dis)allow reading of offloaded data.

Offloading ratio calculation determines how much space is saved by offloading the selected data. This calculation is executed either automatically when a new DataProvider is created, or manually by selecting a specific DataProvider and clicking on Calculate ratio. The initial calculation is just approximate. The offloading ratio can be recalculated to get more accurate values.


Straggler analysis can be executed also separately with the option Straggler Analysis in the button Execute Analysis. It will find all DTPs for given days back ( setting STRAGGLER_DAYS) and offloading selection. Data are displayed per analysis run, more details can be displayed with the button in the column Details of Straggler analysis.


DTPs will be displayed automatically, without execution of analysis. There will be displayed all DTPs ( from which are data loaded into another object ) and also all requirements with status.

More info about requirements: Data Transfer Process (DTP) Including Offloaded Data


To proceed with the Wizard go to the (2208) Step 3. Object adjustment.