Skip to content

Commit 5675dfb

Browse files
v-thepetv-thepet
committed
last batch database-engine
1 parent 3bff06a commit 5675dfb

910 files changed

Lines changed: 3955 additions & 3955 deletions

File tree

Some content is hidden

Large Commits have some content hidden by default. Use the searchbox below for content that may be hidden.

‎docs/2014/analysis-services/TOC.md‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -636,7 +636,7 @@
636636
####### [Server Configuration Utility (Data Mining Add-ins for Excel)](server-configuration-utility-data-mining-add-ins-for-excel.md)
637637
### [PowerPivot for SharePoint](power-pivot-sharepoint/power-pivot-for-sharepoint-ssas.md)
638638
#### [PowerPivot Server Administration and Configuration in Central Administration](power-pivot-sharepoint/power-pivot-server-administration-and-configuration-in-central-administration.md)
639-
##### [Deploy PowerPivot Solutions](power-pivot-sharepoint/deploy-power-pivot-solutions-to-sharepoint.md)
639+
##### [Deploy PowerPivot Solutions](../relational-databases/spatial/point.md)
640640
##### [Create and Configure a PowerPivot Service Application](power-pivot-sharepoint/create-and-configure-power-pivot-service-application-in-ca.md)
641641
##### [Connect a PowerPivot Service Application to a SharePoint Web Application](power-pivot-sharepoint/connect-power-pivot-service-app-to-sharepoint-web-app-in-ca.md)
642642
##### [Activate PowerPivot Feature Integration for Site Collections](power-pivot-sharepoint/activate-power-pivot-integration-for-site-collections-in-ca.md)

‎docs/2014/analysis-services/analysis-services-powershell.md‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -55,7 +55,7 @@ manager: "mblythe"
5555
|-------------|-------------------------------------|
5656
|Multidimensional instances and databases|Supported for local and remote administration.<br /><br /> Merge-partition requires a local connection.|
5757
|Tabular instances and databases|Supported for local and remote administration.<br /><br /> For more information, see [Manage Tabular Models Using PowerShell](http://go.microsoft.com/fwlink/?linkID=227685).|
58-
|PowerPivot for SharePoint instances and databases|Limited support. You can use HTTP connections and the SQLAS provider to view instance and database information.<br /><br /> However, using the cmdlets is not supported. You must not use Analysis Services PowerShell to backup and restore in-memory PowerPivot database, nor should you add or remove roles, process data, or run arbitrary XMLA script.<br /><br /> For configuration purposes, PowerPivot for SharePoint has built-in PowerShell support that is provided separately. For more information, see [PowerShell Reference for PowerPivot for SharePoint](~/analysis-services/powershell/powershell-reference-for-power-pivot-for-sharepoint.md).|
58+
|PowerPivot for SharePoint instances and databases|Limited support. You can use HTTP connections and the SQLAS provider to view instance and database information.<br /><br /> However, using the cmdlets is not supported. You must not use Analysis Services PowerShell to backup and restore in-memory PowerPivot database, nor should you add or remove roles, process data, or run arbitrary XMLA script.<br /><br /> For configuration purposes, PowerPivot for SharePoint has built-in PowerShell support that is provided separately. For more information, see [PowerShell Reference for PowerPivot for SharePoint](../relational-databases/spatial/point.md).|
5959
|Native connections to local cubes<br /><br /> “Data Source=c:\backup\test.cub”|Not supported.|
6060
|HTTP connections to BI semantic model (.bism) connection files in SharePoint<br /><br /> “Data Source=http://server/shared_docs/name.bism”|Not supported.|
6161
|Embedded connections to PowerPivot databases<br /><br /> “Data Source=$Embedded$”|Not supported.|

‎docs/2014/analysis-services/configure-repair-powerpivot-sharepoint-2010.md‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -105,7 +105,7 @@ manager: "mblythe"
105105
||Web Application Database Server|Default, if needed|The default database instance is pre-selected to store the application database, but you can specify a different SQL Server instance in the tool.|
106106
||Web Application Database Name|Default, if needed|The database name is based on the file naming conventions of SharePoint, but you can choose a different name.|
107107
|**Deploy Web Application Solution**|URL|Default, if needed|The Default URL is from the default web application.|
108-
||Maximum File Size (in MB)|Default, if needed|Default setting is 2047. SharePoint document libraries also have a maximum size and the PowerPivot setting should not exceed the document library setting. For more information, see [Configure Maximum File Upload Size &#40;PowerPivot for SharePoint&#41;](power-pivot-sharepoint/configure-maximum-file-upload-size-power-pivot-for-sharepoint.md).|
108+
||Maximum File Size (in MB)|Default, if needed|Default setting is 2047. SharePoint document libraries also have a maximum size and the PowerPivot setting should not exceed the document library setting. For more information, see [Configure Maximum File Upload Size &#40;PowerPivot for SharePoint&#41;](../relational-databases/spatial/point.md).|
109109
|**Create Site Collection**|Site Administrator|Default, if needed|The tool uses the default account. You can override it in the **Create Site Collection** page.|
110110
||Contact E-mail|Default, if needed|If Microsoft Outlook is configured on the server, the tool will use the email address of the current user. Otherwise, a placeholder value is used.|
111111
||Site URL|Default, if needed|The tool creates the site URL, using the same URL naming conventions as SharePoint.|

‎docs/2014/analysis-services/configure-stored-credentials-data-refresh-powerpivot-sharepoint.md‎

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -125,7 +125,7 @@ manager: "mblythe"
125125

126126
### <a name="bkmk_verify"></a> Step 4: Verify account availability in data refresh configuration pages
127127

128-
1. Open a data refresh configuration page for a published workbook that contains PowerPivot data. For instructions on how to open the page, see [Schedule a Data Refresh &#40;PowerPivot for SharePoint&#41;](schedule-a-data-refresh-powerpivot-for-sharepoint.md).
128+
1. Open a data refresh configuration page for a published workbook that contains PowerPivot data. For instructions on how to open the page, see [Schedule a Data Refresh &#40;PowerPivot for SharePoint&#41;](../relational-databases/spatial/point.md).
129129

130130
2. Verify that the **Connect using the credentials saved in Secure Store Service (SSS) to log on to the data source** option is enabled in the data refresh configuration page, and then enter the name of the target application.
131131

@@ -187,7 +187,7 @@ manager: "mblythe"
187187
17. Click **OK**.
188188

189189
## See Also
190-
[Schedule a Data Refresh &#40;PowerPivot for SharePoint&#41;](schedule-a-data-refresh-powerpivot-for-sharepoint.md)
190+
[Schedule a Data Refresh &#40;PowerPivot for SharePoint&#41;](../relational-databases/spatial/point.md)
191191
[PowerPivot Data Refresh with SharePoint 2010](powerpivot-data-refresh-with-sharepoint-2010.md)
192192

193193

‎docs/2014/analysis-services/configure-unattended-data-refresh-account-powerpivot-sharepoint.md‎

Lines changed: 3 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -16,7 +16,7 @@ ms.author: "owend"
1616
manager: "mblythe"
1717
---
1818
# Configure the PowerPivot Unattended Data Refresh Account (PowerPivot for SharePoint)
19-
The PowerPivot unattended data refresh account is a designated account for running PowerPivot data refresh jobs in a SharePoint farm. By configuring it, you enable the **Use the data refresh account configured by the administrator** option in a data refresh schedule page (see below). Workbook authors who schedule data refresh can choose this option if they want to use the PowerPivot unattended data refresh account to run a data refresh job. For more information about how to view the Credentials options in a data refresh schedule, see [Schedule a Data Refresh &#40;PowerPivot for SharePoint&#41;](schedule-a-data-refresh-powerpivot-for-sharepoint.md).
19+
The PowerPivot unattended data refresh account is a designated account for running PowerPivot data refresh jobs in a SharePoint farm. By configuring it, you enable the **Use the data refresh account configured by the administrator** option in a data refresh schedule page (see below). Workbook authors who schedule data refresh can choose this option if they want to use the PowerPivot unattended data refresh account to run a data refresh job. For more information about how to view the Credentials options in a data refresh schedule, see [Schedule a Data Refresh &#40;PowerPivot for SharePoint&#41;](../relational-databases/spatial/point.md).
2020

2121
![SSAS_PowerpivotKJ_DataRefreshCreds](media/ssas-powerpivotkj-datarefreshcreds.gif "SSAS_PowerpivotKJ_DataRefreshCreds")
2222

@@ -146,7 +146,7 @@ manager: "mblythe"
146146

147147
### <a name="bkmk_verify"></a> Step 5: Verify account availability in data refresh configuration pages
148148

149-
1. Open a data refresh configuration page for a published workbook that contains PowerPivot data. For instructions on how to open the page, see [Schedule a Data Refresh &#40;PowerPivot for SharePoint&#41;](schedule-a-data-refresh-powerpivot-for-sharepoint.md).
149+
1. Open a data refresh configuration page for a published workbook that contains PowerPivot data. For instructions on how to open the page, see [Schedule a Data Refresh &#40;PowerPivot for SharePoint&#41;](../relational-databases/spatial/point.md).
150150

151151
2. Verify that the **Use the data refresh account configured by the administrator** option is enabled in the data refresh configuration page.
152152

@@ -188,7 +188,7 @@ manager: "mblythe"
188188

189189
## See Also
190190
[PowerPivot Data Refresh with SharePoint 2010](powerpivot-data-refresh-with-sharepoint-2010.md)
191-
[Schedule a Data Refresh &#40;PowerPivot for SharePoint&#41;](schedule-a-data-refresh-powerpivot-for-sharepoint.md)
191+
[Schedule a Data Refresh &#40;PowerPivot for SharePoint&#41;](../relational-databases/spatial/point.md)
192192
[PowerPivot Data Refresh](power-pivot-sharepoint/power-pivot-data-refresh.md)
193193

194194

‎docs/2014/analysis-services/instances/install-windows/install-or-uninstall-the-power-pivot-for-sharepoint-add-in-sharepoint-2013.md‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -20,7 +20,7 @@ manager: "jhubbard"
2020

2121
- The add-in is not required for SharePoint 2010 deployments.
2222

23-
- The add-in is not required on a single server deployment that includes SharePoint 2013 and [!INCLUDE[ssASnoversion](../../../includes/ssasnoversion-md.md)] in SharePoint mode. The components installed by the add-in are included when you install an [!INCLUDE[ssASnoversion](../../../includes/ssasnoversion-md.md)] server in SharePoint mode. For diagrams of example deployments with the add-in, see [Deployment Topologies for SQL Server BI Features in SharePoint](../../../sql-server/install/deployment-topologies-for-sql-server-bi-features-in-sharepoint.md).
23+
- The add-in is not required on a single server deployment that includes SharePoint 2013 and [!INCLUDE[ssASnoversion](../../../includes/ssasnoversion-md.md)] in SharePoint mode. The components installed by the add-in are included when you install an [!INCLUDE[ssASnoversion](../../../includes/ssasnoversion-md.md)] server in SharePoint mode. For diagrams of example deployments with the add-in, see [Deployment Topologies for SQL Server BI Features in SharePoint](../../../relational-databases/spatial/point.md).
2424

2525
**Note:** This topic describes installing the [!INCLUDE[ssGemini](../../../includes/ssgemini-md.md)] solution files and [!INCLUDE[ssGemini](../../../includes/ssgemini-md.md)] for SharePoint 2013 Configuration tool. After the installation, see the following topic for information on the configuration tool and additional features, [Configure PowerPivot and Deploy Solutions &#40;SharePoint 2013&#41;](../../../analysis-services/instances/install-windows/configure-power-pivot-and-deploy-solutions-sharepoint-2013.md).
2626

‎docs/2014/analysis-services/instances/install-windows/upgrade-workbooks-and-scheduled-data-refresh-sharepoint-2013.md‎

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -83,7 +83,7 @@ manager: "jhubbard"
8383

8484
For more information on Changes to Analysis Services features, see [Behavior Changes to Analysis Services Features in SQL Server 2014](../../behavior-changes-to-analysis-services-features-in-sql-server-2014.md)
8585

86-
For more information on refresh history, see [View Data Refresh History &#40;PowerPivot for SharePoint&#41;](../../power-pivot-sharepoint/view-data-refresh-history-power-pivot-for-sharepoint.md).
86+
For more information on refresh history, see [View Data Refresh History &#40;PowerPivot for SharePoint&#41;](../../../relational-databases/spatial/point.md).
8787

8888
## <a name="bkmk_to_2012sp1_from_2012"></a> Upgrade to Office 2013 workbooks from Versions created by using the 2012 PowerPivot Add-In for Excel
8989
This section describes Upgrading **to** SQL Server 2012 SP1 PowerPivot in Excel 2013 **from** SQL Server 2012 PowerPivot for Excel 2010 workbooks.
@@ -171,6 +171,6 @@ PS C:\Windows\system32> Set-PowerPivotSystemService –WorkbookUpgradeOnDataRefr
171171
[Migrate PowerPivot to SharePoint 2013](migrate-power-pivot-to-sharepoint-2013.md)
172172
[Upgrade PowerPivot for SharePoint](../../../database-engine/install-windows/upgrade-power-pivot-for-sharepoint.md)
173173
[What's New in Analysis Services and Business Intelligence](../../what-s-new-in-analysis-services.md)
174-
[View Data Refresh History &#40;PowerPivot for SharePoint&#41;](../../power-pivot-sharepoint/view-data-refresh-history-power-pivot-for-sharepoint.md)
174+
[View Data Refresh History &#40;PowerPivot for SharePoint&#41;](../../../relational-databases/spatial/point.md)
175175

176176

‎docs/2014/analysis-services/multidimensional-models/create-a-data-source-ssas-multidimensional.md‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -61,7 +61,7 @@ manager: "mblythe"
6161
After you save the data source object in your model, the connection string and password are encrypted. For security purposes, all visible traces of the password are removed from the connection string when you subsequently view it in tools, script, or code.
6262

6363
> [!NOTE]
64-
> By default, [!INCLUDE[ssBIDevStudioFull](../../includes/ssbidevstudiofull-md.md)] does not save passwords with the connection string. If the password is not saved, [!INCLUDE[ssASnoversion](../../includes/ssasnoversion-md.md)] prompts you to enter the password when it is needed. If you choose to save the password, the password is stored in encrypted format in the data connection string. [!INCLUDE[ssASnoversion](../../includes/ssasnoversion-md.md)] encrypts password information for data sources using the database encryption key of the database that contains the data source. With encrypted connection information, you must use [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] Configuration Manager to change the [!INCLUDE[ssASnoversion](../../includes/ssasnoversion-md.md)] service account or password or the encrypted information cannot be recovered. For more information, see [SQL Server Configuration Manager](../../database-engine/sql-server-configuration-manager.md).
64+
> By default, [!INCLUDE[ssBIDevStudioFull](../../includes/ssbidevstudiofull-md.md)] does not save passwords with the connection string. If the password is not saved, [!INCLUDE[ssASnoversion](../../includes/ssasnoversion-md.md)] prompts you to enter the password when it is needed. If you choose to save the password, the password is stored in encrypted format in the data connection string. [!INCLUDE[ssASnoversion](../../includes/ssasnoversion-md.md)] encrypts password information for data sources using the database encryption key of the database that contains the data source. With encrypted connection information, you must use [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] Configuration Manager to change the [!INCLUDE[ssASnoversion](../../includes/ssasnoversion-md.md)] service account or password or the encrypted information cannot be recovered. For more information, see [SQL Server Configuration Manager](../../relational-databases/sql-server-configuration-manager.md).
6565
6666
### Defining Impersonation Information for Data Mining Objects
6767
Data mining queries may be executed in the context of the [!INCLUDE[ssASnoversion](../../includes/ssasnoversion-md.md)] service account, but may also be executed in the context of the user submitting the query or in the context of a specified user. The context in which a query is executed may affect query results. For data mining `OPENQUERY` type operations, you may want the data mining query to execute in the context of the current user or in the context of a specified user (regardless of the user executing the query) rather than in the context of the service account. This enables the query to be executed with limited security credentials. If you want [!INCLUDE[ssASnoversion](../../includes/ssasnoversion-md.md)] to impersonate the current user or to impersonate a specified user, select either the **Use a specific user name and password** or **Use the credentials of the current user** option.

‎docs/2014/analysis-services/power-pivot-sharepoint/activate-power-pivot-integration-for-site-collections-in-ca.md‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -43,7 +43,7 @@ manager: "mblythe"
4343

4444
## See Also
4545
[PowerPivot Server Administration and Configuration in Central Administration](power-pivot-server-administration-and-configuration-in-central-administration.md)
46-
[Initial Configuration &#40;PowerPivot for SharePoint&#41;](../../sql-server/install/initial-configuration-powerpivot-for-sharepoint.md)
46+
[Initial Configuration &#40;PowerPivot for SharePoint&#41;](../../relational-databases/spatial/point.md)
4747
[PowerPivot for SharePoint 2010 Installation](../../sql-server/install/powerpivot-for-sharepoint-2010-installation.md)
4848

4949

‎docs/2014/analysis-services/power-pivot-sharepoint/configuration-setting-reference-power-pivot-for-sharepoint.md‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -74,7 +74,7 @@ manager: "mblythe"
7474
|----------|-------------|------------------|-----------------|
7575
|Start time|04:00 a.m.|1 to 12 hours, where the value is a valid integer within that range.<br /><br /> Type is Time.|Sets the lower limit of a business hour range.|
7676
|End time|08:00 p.m.|1 to 12 hours, where the value is a valid integer within that range.<br /><br /> Type is Time.|Sets the upper limit of a business hour range.|
77-
|PowerPivot Unattended Data Refresh Account|None|A target application ID|This account is used to run data refresh jobs on behalf of a schedule owner.<br /><br /> The unattended data refresh account must be defined in advance before it can be referenced in the service application configuration page. For more information, see [Configure the PowerPivot Unattended Data Refresh Account &#40;PowerPivot for SharePoint&#41;](../configure-unattended-data-refresh-account-powerpivot-sharepoint.md).|
77+
|PowerPivot Unattended Data Refresh Account|None|A target application ID|This account is used to run data refresh jobs on behalf of a schedule owner.<br /><br /> The unattended data refresh account must be defined in advance before it can be referenced in the service application configuration page. For more information, see [Configure the PowerPivot Unattended Data Refresh Account &#40;PowerPivot for SharePoint&#41;](../../relational-databases/spatial/point.md).|
7878
|Allow users to enter custom Windows credentials|Enabled|Boolean|Determines whether the scheduled data refresh configuration page shows an option that allows a schedule owner to specify Windows user account and password to run a data refresh job.<br /><br /> Secure Store Service must be enabled in order for this option to work. For more information, see [Configure Stored Credentials for PowerPivot Data Refresh &#40;PowerPivot for SharePoint&#41;](../configure-stored-credentials-data-refresh-powerpivot-sharepoint.md).|
7979
|Maximum Processing History Length|365|1 to 5000 days|Determines how long data refresh history is retained in the PowerPivot service application database. For more information, see [PowerPivot Usage Data Collection](power-pivot-usage-data-collection.md).|
8080

0 commit comments

Comments
 (0)