New-ASScript

Generates an XMLA script for the specified object.

Syntax

{ New-ASScript [-Create] [-InputObject] <MajorObject> [-ExcludeDependents] [-ExcludePermissions] [-ExcludePartitions] [<CommonParameters>] }

Examples

-------------- Get a Dimension XMLA alter script --------------
    C:\PS>$dim = get-AsDimension localhost\sql08 "Adventure Works DW 2008" "Geography"
    $script = new-AsScript $dim

Returns the XMLA Alter script as a string to the $script variable


-------------- Create an Xmla File --------------
    C:\PS>get-AsDimension localhost\sql08 "Adventure Works DW 2008" "Geography" | new-AsScript $dim > c:\data\DimGeography.xmla

This script pipes the output of the new-AsScript cmdlet to the DimGeography.xmla file.

Parameters

-Create
Setting this flag Will cause the cmdlet to return a CREATE script instead of an ALTER script.

Required? false
Position? named
Default value
Accept pipeline input? false
Accept wildcard characters? false

-InputObject <MajorObject>
This is the object for which the XMLA script will be generated

Required? true
Position? 1
Default value
Accept pipeline input? true (ByValue)
Accept wildcard characters? false

-ExcludeDependents
Excludes dependant objects only scripting the specified object

Required? false
Position? named
Default value
Accept pipeline input? false
Accept wildcard characters? false

-ExcludePermissions
Excludes permissions from the XMLA script

Required? false
Position? named
Default value
Accept pipeline input? false
Accept wildcard characters? false

-ExcludePartitions
Excludes partitions from a Cube script

Required? false
Position? named
Default value
Accept pipeline input? false
Accept wildcard characters? false

<CommonParameters>
This cmdlet supports the common parameters: -Verbose, -Debug,
-ErrorAction, -ErrorVariable, and -OutVariable. For more information,
type, "get-help about_commonparameters".

Last edited Jul 2, 2009 at 3:30 AM by dgosbell, version 1

Comments

No comments yet.