Get-SqlAsPath

NAME 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.





PARAMETERS

-Server <String>

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



Required? true

Position? 1

Default value

Accept pipeline input? false

Accept wildcard characters? false



-CubeDatabase <String>

The name of the cube database to be deployed.



Required? true

Position? 2

Default value

Accept pipeline input? false

Accept wildcard characters? false



<CommonParameters>

This cmdlet supports the common parameters: Verbose, Debug,

ErrorAction, ErrorVariable, WarningAction, WarningVariable,

OutBuffer, PipelineVariable, and OutVariable. For more information, see

about_CommonParameters (https:/go.microsoft.com/fwlink/?LinkID=113216).



INPUTS



OUTPUTS

System.String





NOTES





Written by (c) Dr. John Tunnicliffe, 2019 https://github.com/DrJohnT/DeployCube

This PowerShell script is released under the MIT license http://www.opensource.org/licenses/MIT



-------------------------- EXAMPLE 1 --------------------------



PS C:\\>Get-SqlAsPath -Server localhost -CubeDatabase MyTabularCube;



Returns

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











RELATED LINKS

https://github.com/DrJohnT/DeployCube