New-SPPerformancePointServiceApplication

Creates a new service application for the PerformancePoint Service.

Syntax

New-SPPerformancePointServiceApplication
   [-Name] <String>
   -ApplicationPool <SPIisWebServiceApplicationPoolPipeBind>
   [-AnalyticQueryCellMax <Int32>]
   [-AnalyticQueryLoggingEnabled <Boolean>]
   [-ApplicationCacheEnabled <Boolean>]
   [-ApplicationCacheMinimumHitCount <Int32>]
   [-ApplicationProxyCacheEnabled <Boolean>]
   [-AssignmentCollection <SPAssignmentCollection>]
   [-CommentsDisabled <Boolean>]
   [-CommentsScorecardMax <Int32>]
   [-Confirm]
   [-DatabaseFailoverServer <String>]
   [-DatabaseName <String>]
   [-DatabaseServer <String>]
   [-DatabaseSQLAuthenticationCredential <PSCredential>]
   [-DataSourceQueryTimeoutSeconds <Int32>]
   [-DecompositionTreeMaximum <Int32>]
   [-ElementCacheSeconds <Int32>]
   [-FilterRememberUserSelectionsDays <Int32>]
   [-FilterTreeMembersMax <Int32>]
   [-IndicatorImageCacheSeconds <Int32>]
   [-MSMQEnabled <Boolean>]
   [-MSMQName <String>]
   [-SelectMeasureMaximum <Int32>]
   [-SessionHistoryHours <Int32>]
   [-ShowDetailsInitialRows <Int32>]
   [-ShowDetailsMaxRows <Int32>]
   [-ShowDetailsMaxRowsDisabled <Boolean>]
   [-TrustedContentLocationsRestricted <Boolean>]
   [-TrustedDataSourceLocationsRestricted <Boolean>]
   [-WhatIf]
   [-AnalyticResultCacheMinimumHitCount <Int32>]
   [-DataSourceUnattendedServiceAccountTargetApplication <String>]
   [-FilterSearchResultsMax <Int32>]
   [-UseEffectiveUserName <Boolean>]
   [<CommonParameters>]

Description

The New-SPPerformancePointServiceApplication cmdlet creates a new PerformancePoint Service on the farm.

For permissions and the most current information about Windows PowerShell for SharePoint Products, see the online documentation at SharePoint Server Cmdlets.

Examples

-----------------EXAMPLE------------------------

New-SPPerformancePointServiceApplication -Name PPS_Application_01 -ApplicationPool PPS_Application_Pool_01

This example creates a new PerformancePoint Service application named PPSApp_01 and sets it to run under an application pool named PPS_Application_Pool_01.

Parameters

-AnalyticQueryCellMax

Specifies the maximum number of returned cells in an analytic grid.

A valid integer value from 1 through 1,000,000,000. The default value is 100,000.

Type:Int32
Position:Named
Default value:None
Required:False
Accept pipeline input:False
Accept wildcard characters:False
Applies to:SharePoint Server 2010, SharePoint Server 2013, SharePoint Server 2016, SharePoint Server 2019

-AnalyticQueryLoggingEnabled

Turns on verbose logging of query events.

The type must be one of the following: True or False. The default value is False.

Type:Boolean
Position:Named
Default value:None
Required:False
Accept pipeline input:False
Accept wildcard characters:False
Applies to:SharePoint Server 2010, SharePoint Server 2013, SharePoint Server 2016, SharePoint Server 2019

-AnalyticResultCacheMinimumHitCount

The minimum number of times an analytic report needs to be accessed before caching starts happening.

The default value is 0.

Type:Int32
Position:Named
Default value:None
Required:False
Accept pipeline input:False
Accept wildcard characters:False
Applies to:harePoint Server 2013, SharePoint Server 2016, SharePoint Server 2019

-ApplicationCacheEnabled

Specifies whether the rendered output cache on the application server is on (True) or off (False). The default value is True.

Type:Boolean
Position:Named
Default value:None
Required:False
Accept pipeline input:False
Accept wildcard characters:False
Applies to:SharePoint Server 2010, SharePoint Server 2013, SharePoint Server 2016, SharePoint Server 2019

-ApplicationCacheMinimumHitCount

Specifies the minimum number of times rendered output must be requested before it is added to cache. The default value is 2.

Type:Int32
Position:Named
Default value:None
Required:False
Accept pipeline input:False
Accept wildcard characters:False
Applies to:SharePoint Server 2010, SharePoint Server 2013, SharePoint Server 2016, SharePoint Server 2019

-ApplicationPool

Specifies the existing IIS application pool to run the Web service in for the service application.

The type must be a valid GUID, in the form 12345678-90ab-cdef-1234-567890bcdefgh; a valid name of an application pool (for example, AppPoolName1); or an instance of a valid IISWebServiceApplicationPool object.

Type:SPIisWebServiceApplicationPoolPipeBind
Position:Named
Default value:None
Required:True
Accept pipeline input:True
Accept wildcard characters:False
Applies to:SharePoint Server 2010, SharePoint Server 2013, SharePoint Server 2016, SharePoint Server 2019

-ApplicationProxyCacheEnabled

Specifies rendered output cache on the front end Web server. The default value is True.

Type:Boolean
Position:Named
Default value:None
Required:False
Accept pipeline input:False
Accept wildcard characters:False
Applies to:SharePoint Server 2010, SharePoint Server 2013, SharePoint Server 2016, SharePoint Server 2019

-AssignmentCollection

Manages objects for the purpose of proper disposal. Use of objects, such as SPWeb or SPSite, can use large amounts of memory and use of these objects in Windows PowerShell scripts requires proper memory management. Using the SPAssignment object, you can assign objects to a variable and dispose of the objects after they are needed to free up memory. When SPWeb, SPSite, or SPSiteAdministration objects are used, the objects are automatically disposed of if an assignment collection or the Global parameter is not used.

When the Global parameter is used, all objects are contained in the global store. If objects are not immediately used, or disposed of by using the Stop-SPAssignment command, an out-of-memory scenario can occur.

Type:SPAssignmentCollection
Position:Named
Default value:None
Required:False
Accept pipeline input:True
Accept wildcard characters:False
Applies to:SharePoint Server 2010, SharePoint Server 2013, SharePoint Server 2016, SharePoint Server 2019

-CommentsDisabled

Specifies that users can add comments to scorecard cells.

The type must be one of the following: true or false.

Type:Boolean
Position:Named
Default value:None
Required:False
Accept pipeline input:False
Accept wildcard characters:False
Applies to:SharePoint Server 2010, SharePoint Server 2013, SharePoint Server 2016, SharePoint Server 2019

-CommentsScorecardMax

Specifies the maximum number of comments that can be added to a scorecard. The default value is 1000.

The type must be an integer value from 1 through 1,000,000.

Type:Int32
Position:Named
Default value:None
Required:False
Accept pipeline input:False
Accept wildcard characters:False
Applies to:SharePoint Server 2010, SharePoint Server 2013, SharePoint Server 2016, SharePoint Server 2019

-Confirm

Prompts you for confirmation before executing the command. For more information, type the following command: get-help about_commonparameters

Type:SwitchParameter
Aliases:cf
Position:Named
Default value:None
Required:False
Accept pipeline input:False
Accept wildcard characters:False
Applies to:SharePoint Server 2010, SharePoint Server 2013, SharePoint Server 2016, SharePoint Server 2019

-DatabaseFailoverServer

Specifies the name of the database server that contains the PerformancePoint Services database that must be mirrored.

This parameter was introduced in SharePoint Server with Service Pack 1 (SP1) and SharePoint Foundation with Service Pack 1 (SP1).

Type:String
Position:Named
Default value:None
Required:False
Accept pipeline input:False
Accept wildcard characters:False
Applies to:SharePoint Server 2010, SharePoint Server 2013, SharePoint Server 2016, SharePoint Server 2019

-DatabaseName

Specifies the name of the PerformancePoint Services database that will be created when the service application is provisioned.

This parameter was introduced in SharePoint Server with Service Pack 1 (SP1) and SharePoint Foundation with Service Pack 1 (SP1).

Type:String
Position:Named
Default value:None
Required:False
Accept pipeline input:False
Accept wildcard characters:False
Applies to:SharePoint Server 2010, SharePoint Server 2013, SharePoint Server 2016, SharePoint Server 2019

-DatabaseServer

Specifies the name of the database server where the PerformancePoint Services database will be created. This should be the same server name that is used for the SharePoint content and configuration databases.

The value may be written as SQL instance\server if it is not referring to the default instance.

This parameter was introduced in SharePoint Server with Service Pack 1 (SP1) and SharePoint Foundation with Service Pack 1 (SP1).

Type:String
Position:Named
Default value:None
Required:False
Accept pipeline input:False
Accept wildcard characters:False
Applies to:SharePoint Server 2010, SharePoint Server 2013, SharePoint Server 2016, SharePoint Server 2019

-DatabaseSQLAuthenticationCredential

Determines whether to use Windows authentication or SQL Server authentication when connecting to a PerformancePoint Services database.

This parameter was introduced in SharePoint Server with Service Pack 1 (SP1) and SharePoint Foundation with Service Pack 1 (SP1).

Type:PSCredential
Position:Named
Default value:None
Required:False
Accept pipeline input:False
Accept wildcard characters:False
Applies to:SharePoint Server 2010, SharePoint Server 2013, SharePoint Server 2016, SharePoint Server 2019

-DataSourceQueryTimeoutSeconds

Specifies the time, in seconds, before a data source query times out. The default value is 300.

The type must be an integer value in the range of 1 to 36,000.

Type:Int32
Position:Named
Default value:None
Required:False
Accept pipeline input:False
Accept wildcard characters:False
Applies to:SharePoint Server 2010, SharePoint Server 2013, SharePoint Server 2016, SharePoint Server 2019

-DataSourceUnattendedServiceAccountTargetApplication

The name of the Secure Store Application that will be used by default to access data sources.

Type:String
Position:Named
Default value:None
Required:False
Accept pipeline input:False
Accept wildcard characters:False
Applies to:SharePoint Server 2016, SharePoint Server 2019

-DecompositionTreeMaximum

Specifies the maximum number of items (per level) returned to the decomposition tree visualization.

A valid integer value from 1 through 1,000,000. The default value is 25.

Type:Int32
Position:Named
Default value:None
Required:False
Accept pipeline input:False
Accept wildcard characters:False
Applies to:SharePoint Server 2010, SharePoint Server 2013, SharePoint Server 2016, SharePoint Server 2019

-ElementCacheSeconds

Specifies the first class object cache expiration time. The default value is 15.

Type:Int32
Position:Named
Default value:None
Required:False
Accept pipeline input:False
Accept wildcard characters:False
Applies to:SharePoint Server 2010, SharePoint Server 2013, SharePoint Server 2016, SharePoint Server 2019

-FilterRememberUserSelectionsDays

Specifies the number of days that user filter selections are remembered. The default value is 90.

The type must be an integer value from 1 through 10,000.

Type:Int32
Position:Named
Default value:None
Required:False
Accept pipeline input:False
Accept wildcard characters:False
Applies to:SharePoint Server 2010, SharePoint Server 2013, SharePoint Server 2016, SharePoint Server 2019

-FilterSearchResultsMax

The maximum number of items to return on a Dashboard when viewing a filter.

The default value is 5000.

Type:Int32
Position:Named
Default value:None
Required:False
Accept pipeline input:False
Accept wildcard characters:False
Applies to:SharePoint Server 2016, SharePoint Server 2019

-FilterTreeMembersMax

Specifies the maximum number of records to show in filter treeview control. The default value is 500.

The type must be an integer value from 1 through 100,000.

Type:Int32
Position:Named
Default value:None
Required:False
Accept pipeline input:False
Accept wildcard characters:False
Applies to:SharePoint Server 2010, SharePoint Server 2013, SharePoint Server 2016, SharePoint Server 2019

-IndicatorImageCacheSeconds

Specifies the time, in seconds, that key performance indicator (KPI) icons are cached. The default value is 10.

The type must be an integer value from 1 through 3,600.

Type:Int32
Position:Named
Default value:None
Required:False
Accept pipeline input:False
Accept wildcard characters:False
Applies to:SharePoint Server 2010, SharePoint Server 2013, SharePoint Server 2016, SharePoint Server 2019

-MSMQEnabled

Specifies that notifications are sent to Microsoft Message Queuing (MSMQ) on content change.

The type must be one of the following: true or false. The default value is False.

Type:Boolean
Position:Named
Default value:None
Required:False
Accept pipeline input:False
Accept wildcard characters:False
Applies to:SharePoint Server 2010, SharePoint Server 2013, SharePoint Server 2016, SharePoint Server 2019

-MSMQName

Specifies the name of the queue. The queue name can contain a maximum of 380 characters, and cannot contain the following characters: CR (ASCII 13), LF (ASCII 10), backslash (\), plus sign (+, comma (,), or quotation marks ("").

The type must be a valid MSMQ name; for example, MessageQueue1.

Type:String
Position:Named
Default value:None
Required:False
Accept pipeline input:False
Accept wildcard characters:False
Applies to:SharePoint Server 2010, SharePoint Server 2013, SharePoint Server 2016, SharePoint Server 2019

-Name

Specifies the name of the new PerformancePoint Service application.

The type must be a valid name of a PerformancePoint Service application; for example, PerfPointApp1.

Type:String
Position:1
Default value:None
Required:True
Accept pipeline input:True
Accept wildcard characters:False
Applies to:SharePoint Server 2010, SharePoint Server 2013, SharePoint Server 2016, SharePoint Server 2019

-SelectMeasureMaximum

Specifies the maximum number of measures to show in a dashboard Select Measure control. The default value is 1000.

The type must be an integer value from 1 through 1,000,000.

Type:Int32
Position:Named
Default value:None
Required:False
Accept pipeline input:False
Accept wildcard characters:False
Applies to:SharePoint Server 2010, SharePoint Server 2013, SharePoint Server 2016, SharePoint Server 2019

-SessionHistoryHours

Specifies the number of hours between clearing expired user navigation history. The default value is 2.

The type must be an integer value from 1 through 48.

Type:Int32
Position:Named
Default value:None
Required:False
Accept pipeline input:False
Accept wildcard characters:False
Applies to:SharePoint Server 2010, SharePoint Server 2013, SharePoint Server 2016, SharePoint Server 2019

-ShowDetailsInitialRows

Specifies the initial number of rows to retrieve for show details. The default value is 1,000.

The type must be an integer value from 1 through 100,000.

Type:Int32
Position:Named
Default value:None
Required:False
Accept pipeline input:False
Accept wildcard characters:False
Applies to:SharePoint Server 2010, SharePoint Server 2013, SharePoint Server 2016, SharePoint Server 2019

-ShowDetailsMaxRows

Specifies the maximum number of rows to retrieve for show details.

The type must be an integer value from 1 through 1,000,000. The default value is 10,000.

Type:Int32
Position:Named
Default value:None
Required:False
Accept pipeline input:False
Accept wildcard characters:False
Applies to:SharePoint Server 2010, SharePoint Server 2013, SharePoint Server 2016, SharePoint Server 2019

-ShowDetailsMaxRowsDisabled

Turns off the ShowDetailsInitialRows setting. If set to True, Analysis Services controls limit.

The type must be one of the following: True or False. The default value is False.

Type:Boolean
Position:Named
Default value:None
Required:False
Accept pipeline input:False
Accept wildcard characters:False
Applies to:SharePoint Server 2010, SharePoint Server 2013, SharePoint Server 2016, SharePoint Server 2019

-TrustedContentLocationsRestricted

Specifies that only specified locations are trusted. The default setting is false (trust all content locations).

The type must be one of the following: True or False. The default value is False.

Type:Boolean
Position:Named
Default value:None
Required:False
Accept pipeline input:False
Accept wildcard characters:False
Applies to:SharePoint Server 2010, SharePoint Server 2013, SharePoint Server 2016, SharePoint Server 2019

-TrustedDataSourceLocationsRestricted

Specifies that only specified locations are trusted. The default setting is false (trust all data source locations).

The type must be one of the following: True or False. The default value is False.

Type:Boolean
Position:Named
Default value:None
Required:False
Accept pipeline input:False
Accept wildcard characters:False
Applies to:SharePoint Server 2010, SharePoint Server 2013, SharePoint Server 2016, SharePoint Server 2019

-UseEffectiveUserName

Enables the use of the Analysis Services Effective User Name feature.

The type must be one of the following: True or False. The default value is False.

Type:Boolean
Position:Named
Default value:None
Required:False
Accept pipeline input:False
Accept wildcard characters:False
Applies to:SharePoint Server 2016, SharePoint Server 2019

-WhatIf

Displays a message that describes the effect of the command instead of executing the command. For more information, type the following command: get-help about_commonparameters

Type:SwitchParameter
Aliases:wi
Position:Named
Default value:None
Required:False
Accept pipeline input:False
Accept wildcard characters:False
Applies to:SharePoint Server 2010, SharePoint Server 2013, SharePoint Server 2016, SharePoint Server 2019