Skip to content

Latest commit

 

History

History
88 lines (66 loc) · 2.13 KB

Get-SqlAsPath.md

File metadata and controls

88 lines (66 loc) · 2.13 KB
external help file Module Name online version schema
DeployCube-help.xml
DeployCube
2.0.0

Get-SqlAsPath

SYNOPSIS

Returns the path to a specific cube database in the form: SQLSERVER:\SQLAS\YourServer\DEFAULT\Databases\YourCubeDatabase or SQLSERVER:\SQLAS\YourServer\YourInstance\Databases\YourCubeDatabase Useful, when wishing to use the SqlServer module to navigate a cube structure.

SYNTAX

Get-SqlAsPath [-Server] <String> [-CubeDatabase] <String> [<CommonParameters>]

DESCRIPTION

Returns the path to a specific cube database in the form: SQLSERVER:\SQLAS\YourServer\DEFAULT\Databases\YourCubeDatabase or SQLSERVER:\SQLAS\YourServer\YourInstance\Databases\YourCubeDatabase Useful, when wishing to use the SqlServer module to navigate a cube structure.

EXAMPLES

EXAMPLE 1

Get-SqlAsPath -Server localhost -CubeDatabase MyTabularCube;

Returns SQLSERVER:\SQLAS\localhost\DEFAULT\Databases\MyTabularCube

PARAMETERS

-Server

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

Type: String
Parameter Sets: (All)
Aliases:

Required: True
Position: 1
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: 2
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

System.String

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