Skip to content

Latest commit

 

History

History
269 lines (216 loc) · 7.9 KB

Update-AnalysisServicesConfig.md

File metadata and controls

269 lines (216 loc) · 7.9 KB
external help file Module Name online version schema
DeployCube-help.xml
DeployCube
2.0.0

Update-AnalysisServicesConfig

SYNOPSIS

Updates the various config files generated alongside the asdatabase file so they can be deployed to the correct server with the correct processing options.

SYNTAX

Update-AnalysisServicesConfig [-AsDatabasePath] <String> [-Server] <String> [-CubeDatabase] <String>
 [[-ProcessingOption] <String>] [[-TransactionalDeployment] <Boolean>] [[-PartitionDeployment] <String>]
 [[-RoleDeployment] <String>] [[-ConfigurationSettingsDeployment] <String>]
 [[-OptimizationSettingsDeployment] <String>] [[-WriteBackTableCreation] <String>] [[-UserID] <String>]
 [[-Password] <String>] [<CommonParameters>]

DESCRIPTION

Updates the various config files generated alongside the asdatabase file so they can be deployed to the correct server with the correct processing options.

This PowerShell function updates the various config files (listed below) which are needed to deploy the cube:

  • [model name].asdatabase which contains the declarative definitions for all SSAS objects.
  • [model name].deploymenttargets whcih Contains the name of the target SSAS instance and database.
  • [model name].deploymentoptions which contains options such as whether deployment is transactional and whether objects should be processed.
  • [model name].configsettings which is for Multidimensional only and contains environment specific settings such as data source connections and object storage locations. These settings override whats in [model name].asdatabase.

EXAMPLES

EXAMPLE 1

Update-AnalysisServicesConfig -AsDatabasePath $AsDatabasePath -Server $Server -CubeDatabase $CubeDatabase;

EXAMPLE 2

Update-AnalysisServicesConfig -AsDatabasePath $AsDatabasePath -Server $Server -CubeDatabase $CubeDatabase -ProcessingOption $ProcessingOption -TransactionalDeployment $TransactionalDeployment -PartitionDeployment $PartitionDeployment -RoleDeployment $RoleDeployment -ConfigurationSettingsDeployment $ConfigurationSettingsDeployment -OptimizationSettingsDeployment $OptimizationSettingsDeployment -WriteBackTableCreation $WriteBackTableCreation;

PARAMETERS

-AsDatabasePath

Full path to your database XMLA or TMSL file which has a .asdatabase file extension (e.g. C:\Dev\YourDB\bin\Debug\YourDB.asdatabase)

Type: String
Parameter Sets: (All)
Aliases:

Required: True
Position: 1
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-Server

Name of the target SSAS server, including instance and port if required.

Type: String
Parameter Sets: (All)
Aliases:

Required: True
Position: 2
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-CubeDatabase

The name of the cube database to be deployed.

Type: String
Parameter Sets: (All)
Aliases:

Required: True
Position: 3
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-ProcessingOption

Determines how the newely deployed cube is processed after deployment. Strongly recommend using the default "DoNotProcess" option as the connection to your source database may not be correct and need adjustment post-deployment.

  • Valid options are: Full, Default and DoNotProcess.
  • Default value: 'DoNotProcess'.
  • 'Full': processes all the objects in the cube database. When Full processing is executed against an object that has already been processed, Analysis Services drops all data in the object and then processes the object.
  • 'Default': detects the process state of cube database objects, and performs the processing necessary to deliver unprocessed or partially processed objects to a fully processed state.
  • 'DoNotProcess': means no processing is performed.
Type: String
Parameter Sets: (All)
Aliases:

Required: False
Position: 4
Default value: DoNotProcess
Accept pipeline input: False
Accept wildcard characters: False

-TransactionalDeployment

Determines if the cube is deployed within one transaction for both metadata changes and processing commands.

  • If this option is True, Analysis Services deploys all metadata changes and all process commands within a single transaction.
  • If this option is False (default), Analysis Services deploys the metadata changes in a single transaction, and deploys each processing command in its own transaction.
Type: Boolean
Parameter Sets: (All)
Aliases:

Required: False
Position: 5
Default value: False
Accept pipeline input: False
Accept wildcard characters: False

-PartitionDeployment

Determines if partitions are deployed.

  • Valid options are: 'DeployPartitions' and 'RetainPartitions'.
  • Default value: 'DeployPartitions'.
  • 'DeployPartitions': New partitions are deployed. Existing partitions are removed.
  • 'RetainPartitions': Existing partitions are retained. New partitions are not deployed.
Type: String
Parameter Sets: (All)
Aliases:

Required: False
Position: 6
Default value: DeployPartitions
Accept pipeline input: False
Accept wildcard characters: False

-RoleDeployment

Determines if the roles and members are deployed.

  • Valid options are: 'DeployRolesAndMembers', 'DeployRolesRetainMembers' and 'RetainRoles'.
  • Default value: 'DeployRolesRetainMembers'.
  • 'DeployRolesRetainMembers': Existing roles and role members in the destination database are retained, and only new roles and role members are deployed.
  • 'DeployRolesAndMembers': All existing roles and members in the destination database are replaced by the roles and members being deployed.
  • 'RetainRoles': Existing roles and role members in the destination database are retained, and no new roles are deployed.
Type: String
Parameter Sets: (All)
Aliases:

Required: False
Position: 7
Default value: DeployRolesRetainMembers
Accept pipeline input: False
Accept wildcard characters: False

-ConfigurationSettingsDeployment

  • Valid options are: 'Retain' and 'Deploy'.
  • Default value: 'Deploy'.
Type: String
Parameter Sets: (All)
Aliases:

Required: False
Position: 8
Default value: Deploy
Accept pipeline input: False
Accept wildcard characters: False

-OptimizationSettingsDeployment

  • Valid options are: 'Retain' and 'Deploy'.
  • Default value: 'Deploy'.
Type: String
Parameter Sets: (All)
Aliases:

Required: False
Position: 9
Default value: Deploy
Accept pipeline input: False
Accept wildcard characters: False

-WriteBackTableCreation

Determines if a write back table is created

  • Valid only for multidimensional cubes. Determines if the deployment should create the writeback table.
  • Valid options are: 'Create', 'CreateAlways' and 'UseExisting'.
  • Default value: 'UseExisting'.
Type: String
Parameter Sets: (All)
Aliases:

Required: False
Position: 10
Default value: UseExisting
Accept pipeline input: False
Accept wildcard characters: False

-UserID

{{ Fill UserID Description }}

Type: String
Parameter Sets: (All)
Aliases:

Required: False
Position: 11
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-Password

{{ Fill Password Description }}

Type: String
Parameter Sets: (All)
Aliases:

Required: False
Position: 12
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

CommonParameters

This cmdlet supports the common parameters: -Debug, -ErrorAction, -ErrorVariable, -InformationAction, -InformationVariable, -OutVariable, -OutBuffer, -PipelineVariable, -Verbose, -WarningAction, and -WarningVariable. For more information, see about_CommonParameters.

INPUTS

OUTPUTS

NOTES

Written by (c) Dr. John Tunnicliffe, 2019-2021 https://github.com/DrJohnT/DeployCube This PowerShell script is released under the MIT license http://www.opensource.org/licenses/MIT

RELATED LINKS

https://github.com/DrJohnT/DeployCube