SSAS Actions

Last Modified on 28 February 2023

EOL: SentryOne Test reached its end of life date on June 15, 2022. See the Solarwinds End of Life Policy for more information.

The SSAS actions bring cubes, dimensions, databases or tables to a fully processed state. Choose which processing mode to use depending on your preferences. These actions prepare a test by ensuring they are only testing against updated objects.

Process Cube

IconDescription
SentryOne Test Process CubeThe Process Cube action helps bring a cube to a fully processed state. This action helps prepare a test by ensuring it's only testing against an updated cube.

Important:  The Process Cube action supports the following model types using the listed compatibilty levels:

  • Multidimensional Model with compatibility level 1050 and higher
  • Tabular Model with compatibility levels below 1200

Use the Process Table action to process Tabular tables set to compatibility levels 1200 or higher.

SentryOne Test Process Cube Element Editor

Once the editor loads, you need to input the following properties:

FunctionDescription
Server
The server location for the cube you want to process. Select Connect to load all cubes stored on the server.
Process Mode
The following processing modes are available:
ModeDescription
Default
Does the smallest amount of work required to bring the selected cube to a fully processed state.
Full
Discards the data from the selected cube and completely rebuilds it.
Data
Discards the data from the selected cube and rebuilds the data without building indexes.
Clear
Discards the data from the selected cube.
Index
Rebuilds the indexes for the selected cube. This requires the cube to already have its data built.
Defrag
Optimizes the selected cube.

Fail on Process Fail
Determines if the test fails if the process cube action fails.
Selected
Displays the currently selected cube.
Server Tree
After connecting, the server tree displays all available cubes.

Process Database

IconDescription
SentryOne Test Process DatabaseThe Process Database action helps bring a cube to a fully processed state. This action helps prepare a test by ensuring it's only testing against an updated database.

SentryOne Test Process Database Element Editor

Once the editor loads, you need to input the following properties:

FunctionDescription
Server
The server location for the database the user is planning to process. Select Connect to load all databases stored on the server.
Process Mode
The following processing modes are available:
ModeDescription
Default
Does the smallest amount of work required to bring the selected database to a fully processed state.
Full
Discards the data from the selected database and completely rebuilds it.
Clear
Discards the data from the selected database.

Fail on Process Fail
Determines if the test fails if the process database action fails.
Selected
Displays the currently selected database.
Server Tree
After connecting, the server tree displays all available databases.

Process Dimension

IconDescription
SentryOne Test Process DimensionThe Process Dimension action helps bring a cube to a fully processed state. This action helps prepare a test by ensuring it's only testing against an updated dimension.

SentryOne Test Process Dimension Element EditorOnce the editor loads, you need to input the following properties:

FunctionDescription
Server
The server location for the dimension you want to process. Select Connect to load all dimensions stored on the server.
Process Mode
The following processing modes are available:
ModeDescription
Default
Does the smallest amount of work required to bring the selected dimension to a fully processed state.
Full
Discards the data from the selected dimension and completely rebuilds it.
Data
Discards the data from the selected dimension and rebuilds the data without building indexes.
Clear
Discards the data from the selected dimension.
Index
Rebuilds the indexes for the selected dimension. This requires the dimension to already have its data built.
Update
Incrementally brings the selected dimension to a fully processed state.

Fail on Process Fail
Determines if the test should fails if the process dimension action fails.
Selected
Displays the currently selected dimension.
Server Tree
After connecting, the server tree displays all available dimensions.

Process Table

IconDescription
SentryOne Test Process TableThe Process Table action helps bring a cube to a fully processed state. This action helps prepare a test by ensuring it's only testing against an updated table.

Important:  The Process Table action supports the following model types using the listed compatibilty levels:

  • Tabular Model with compatibility levels above 1200

Use the Process Cube action to process Tabular tables set to compatibility levels below 1200.

SentryOne Test Process Table Element EditorOnce the editor loads, you need to input the following properties:

FunctionDescription
Server
The server location for the table you want to process. Select Connect to load all tables stored on the server.
Process Mode
The following processing modes are available:
ModeDescription
Default
Does the smallest amount of work required to bring the selected table to a fully processed state.
Full
Discards the data from the selected table and completely rebuilds it.
Data
Discards the data from the selected table and rebuilds the data without building indexes.
Clear
 Discards the data from the selected table.
Defrag
 Optimizes the selected table.

Fail on Process Fail
Determines if the test fails if the process table action fails.
Selected
Displays the currently selected table.
Server Tree
After connecting, the server tree displays all available tables.

Related Articles

  • None
Was this article helpful?
Thank you for your feedback! It has been submitted to the SentryOne Docs team.
User Icon

Thank you for your feedback. It has been submitted to the documentation team.

Copyright © SQL Sentry, LLC. All rights reserved.