Skip to content

Commit 4601bf2

Browse files
v-thepetv-thepet
committed
Migration: migration from Caps to OP
1 parent 0d26729 commit 4601bf2

11,416 files changed

Lines changed: 881234 additions & 193 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/TOC.md‎

Lines changed: 7 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,7 @@
1+
# [Developer Reference for SQL Server 2014](developer-reference-for-sql-server-2014.md)
2+
# [Glossary](glossary.md)
3+
# [SQL Server Index Design Guide](sql-server-index-design-guide.md)
4+
# [SQL Server Transaction Locking and Row Versioning Guide](sql-server-transaction-locking-and-row-versioning-guide.md)
5+
# [SQL Server Transaction Log Architecture and Management](sql-server-transaction-log-architecture-and-management.md)
6+
# [Books Online for SQL Server 2014](books-online-for-sql-server-2014.md)
7+
# [Case Study: Building an Enterprise Ecosystem with Microsoft Dynamics ERP and SQL Server 2014 Replication for Scalability and Performance](case-study-building-an-enterprise-ecosystem.md)

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

Lines changed: 1057 additions & 0 deletions
Large diffs are not rendered by default.

‎docs/2014/analysis-services/accuracy-chart-sql-server-data-mining-add-ins.md‎

Lines changed: 87 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,87 @@
1+
---
2+
title: "Accuracy Chart (SQL Server Data Mining Add-ins) | Microsoft Docs"
3+
ms.custom: ""
4+
ms.date: "06/13/2017"
5+
ms.prod: "sql-server-2014"
6+
ms.reviewer: ""
7+
ms.suite: ""
8+
ms.technology:
9+
- "analysis-services"
10+
ms.tgt_pltfrm: ""
11+
ms.topic: "article"
12+
helpviewer_keywords:
13+
- "accuracy chart"
14+
- "mining models, validating"
15+
- "mining models, charting"
16+
- "lift chart"
17+
- "mining models, testing"
18+
- "lift [data mining]"
19+
ms.assetid: 303973b4-71c0-4cfc-b7bc-92218b52509d
20+
caps.latest.revision: 19
21+
author: "Minewiskan"
22+
ms.author: "owend"
23+
manager: "mblythe"
24+
---
25+
# Accuracy Chart (SQL Server Data Mining Add-ins)
26+
![Accuracy Chart button in Data Mining ribbon](../../2014/analysis-services/media/dmc-accchart.gif "Accuracy Chart button in Data Mining ribbon")
27+
28+
An accuracy chart enables you to apply a model to a new set of data and then evaluate how well the model performs. The accuracy chart created by this wizard is a *lift chart*, which is a type of chart that is frequently used to measure the accuracy of a data mining model. This type of accuracy chart displays a graphical representation of the improvement that you obtain from using the specified data mining model, as compared to random predictions, and to the ideal case where 100 percent of predictions are accurate. You can compare multiple models within a single chart.
29+
30+
## Example
31+
Consider the case in which the Marketing department at Adventure Works Cycles wants to create a targeted mailing campaign. From past campaigns, they know that a 10 percent response rate is typical. They have a list of 10,000 potential customers stored in a table in the database. Based on the typical response rate, they can expect 1,000 customers to respond.
32+
33+
However, because they can afford to mail an advertisement to only 5,000 customers, the Marketing department uses a mining model to target the 5,000 customers who are most likely to respond.
34+
35+
If the company randomly selects 5,000 customers, they can expect to receive only 500 positive responses, because only 10 percent of those who are targeted typically respond. This scenario is what the random line in the lift chart represents.
36+
37+
However, if the Marketing department uses a mining model to target their mailing, and if the model were perfect, the company could expect to receive 1,000 responses by mailing an advertisement to the 1,000 potential customers recommended by the model. This scenario is represented by the ideal line in the lift chart.
38+
39+
## Using the Accuracy Chart Wizard
40+
To create an accuracy chart, you must reference an existing data mining structure. You can measure the accuracy of multiple models that are based on that structure, as long as they predict the same thing.
41+
42+
If you are not sure which structures are available, you can browse the server. For more information, see [Browsing Models in Excel (SQL Server Data Mining Add-ins)](../../2014/analysis-services/browsing-models-in-excel-sql-server-data-mining-add-ins.md).
43+
44+
#### To create an accuracy chart
45+
46+
1. Click the **Data Mining Client** ribbon.
47+
48+
2. In the **Accuracy and Validation** group, click **Accuracy Chart**.
49+
50+
3. In the **Select Structure or Model** dialog box, choose the model that you want to evaluate. Click **Next**.
51+
52+
> [!NOTE]
53+
> You must choose a model that closely matches the data you intend to test.
54+
55+
4. In the **Specify Column to Predict and Value to Predict** dialog box, choose the column that you want to predict, and a target value, if appropriate. Click **Next**.
56+
57+
For example, in the example above, you might choose the column that models the customer response, and specify the target value as "Probably Will Buy".
58+
59+
> [!NOTE]
60+
> You cannot predict a continuous value. However, you can discretize the column by separating the values into discrete ranges. You must do this before creating the data mining model.
61+
62+
5. In the **Select Source Data** dialog box, specify the source of the data that you will pass through the model in order to create a prediction.
63+
64+
6. If you are using an external source of data, and not the test data that is stored with the model, in the **Specify Relationships** dialog box, map the columns in the new source data to the columns used in the data mining model.
65+
66+
If the column names are similar, the wizard will automatically map them. Although some columns in your input data may be irrelevant to analysis and can be ignored, some columns are required for the data mining model to process the input. Such columns might include a transaction ID, the target value, or columns used for prediction. If you fail to map a column that is required, the wizard will provide a warning message.
67+
68+
7. Click **Finish**.
69+
70+
The wizard creates a report that includes the lift chart and underlying data.
71+
72+
### Requirements
73+
If you are predicting a discrete value, you must select the target value that you want to predict. For example, if your data is categorized with a response "Yes: Buy" as 1 and the response "No: Do Not Buy" as 2, you must specify either 1 or 2 as the prediction values. However, if you want to predict a range of values, you can compare only two values at a time. For example, if you want to predict a score above 5, you might have to relabel your source data and create a new model that separates the results into two sets: those greater than 5 and those less than 5. You can then compare the accuracy of those two groups.
74+
75+
## Understanding Accuracy
76+
You can create two types of charts, one in which you specify a state of the predictable column, and one in which you do not specify the state.
77+
78+
If you specify the state of the predictable column, the x-axis of the chart represents the percentage of the test dataset that is used to compare the predictions. The y-axis of the chart represents the percentage of values that are predicted to be the specified state.
79+
80+
If you do not specify the state of the predictable column, the chart shows the accuracy of the model for all possible predictions.
81+
82+
For more information about how a lift chart works, and how accuracy is calculated based on the random and ideal prediction lines, see the topic "Lift Chart" in [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] Books Online.
83+
84+
## See Also
85+
[Validating Models and Using Models for Prediction (Data Mining Add-ins for Excel)](../../2014/analysis-services/validating-models-and-using-models-for-prediction-data-mining-add-ins-for-excel.md)
86+
87+

‎docs/2014/analysis-services/action-form-editor-cube-designer-analysis-services-multidimensional-data.md‎

Lines changed: 117 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,117 @@
1+
---
2+
title: "Action Form Editor (Actions Tab, Cube Designer) (Analysis Services - Multidimensional Data) | Microsoft Docs"
3+
ms.custom: ""
4+
ms.date: "06/13/2017"
5+
ms.prod: "sql-server-2014"
6+
ms.reviewer: ""
7+
ms.suite: ""
8+
ms.technology:
9+
- "analysis-services"
10+
ms.tgt_pltfrm: ""
11+
ms.topic: "article"
12+
f1_keywords:
13+
- "sql12.asvs.cubeeditor.actionexpression.action.f1"
14+
ms.assetid: c363a29b-6099-473c-9625-460cc15b3d95
15+
caps.latest.revision: 24
16+
author: "Minewiskan"
17+
ms.author: "owend"
18+
manager: "mblythe"
19+
---
20+
# Action Form Editor (Actions Tab, Cube Designer) (Analysis Services - Multidimensional Data)
21+
Use the Action Form Editor pane on the **Actions** tab in Cube Designer to create and modify standard actions.
22+
23+
## Options
24+
**Name**
25+
Type the name of the action.
26+
27+
**Action Target**
28+
Expand to view the **Target type** and **Target object** options.
29+
30+
**Target type**
31+
Select the type of object to which the action is to be associated. The server returns to the client only those actions that apply to the object of the specified type. The action is available to the client if the **Condition** is met and if the objects specified in the following table are selected.
32+
33+
|Value|Selected Object|
34+
|-----------|---------------------|
35+
|Attribute members|A member is selected from a level based on the attribute in **Target object**.|
36+
|Cells|The named set in **Target object** is selected. Select **All cells** to select all of the cells in the cube.|
37+
|Cube|The cube in **Target object** is selected. Select CURRENTCUBE to use the current cube.<br /><br /> Note: Using CURRENTCUBE provides additional portability in cases where the cube may be renamed or the action copied to other cubes. It is recommended that you use CURRENTCUBE to represent the current cube.|
38+
|Dimension members|A member of the dimension in **Target object** is selected.|
39+
|Hierarchy|The hierarchy in **Target object** is selected.|
40+
|Hierarchy members|A member within the hierarchy in **Target object** is selected.|
41+
|Level|The level in **Target object** is selected.|
42+
|Level members|A member within the level in **Target object** is selected.|
43+
44+
**Target object**
45+
Select the object to which the action is to be associated. The [!INCLUDE[ssASnoversion](../../includes/ssasnoversion-md.md)] instance returns to the client only those actions that apply to the selected object. The list of available objects is constrained by the choice of **Target type**.
46+
47+
**Condition (Optional)**
48+
Enter the Multidimensional Expressions (MDX) expression that describes an optional condition, used in conjunction with **Target object**, which further restricts when the action is available. The expression must return a Boolean value that, if true, indicates the action is available.
49+
50+
Drag selected elements from the **Calculation Tools** pane to this option to include the MDX syntax for the selected element.
51+
52+
**Action Content**
53+
Expand to view the **Type** and **Action expression** options.
54+
55+
**Type**
56+
Select the type of action to take when the action is run. The following action types are available:
57+
58+
|Value|Description|
59+
|-----------|-----------------|
60+
|Dataset|Returns a Multidimensional Expressions (MDX) statement, representing a multidimensional dataset, to be run and displayed by the client application.|
61+
|Proprietary|Returns a proprietary string that can be interpreted by client applications associated with the **Application** setting for this action.|
62+
|Rowset|Returns a Multidimensional Expressions (MDX) statement, representing a tabular rowset, to be run and displayed by the client application.|
63+
|Statement|Returns a command string to be run by the client application.|
64+
|URL|Returns a Uniform Resource Location (URL) string to be opened by the client application, typically with an Internet browser.|
65+
66+
For more information about action types, see [Actions &#40;Analysis Services - Multidimensional Data&#41;](../../2014/analysis-services/actions-analysis-services-multidimensional-data.md).
67+
68+
**Action expression**
69+
Type the Multidimensional Expressions (MDX) expression that returns the string returned by the action to the client application for execution.
70+
71+
**Additional Properties**
72+
Expand to view the **Invocation**, **Application**, **Description**, **Caption**, and **Caption Is MDX** options.
73+
74+
**Invocation**
75+
Select the setting that indicates when the action should be carried out.
76+
77+
> [!NOTE]
78+
> This option only provides a recommendation to a client application as to when to execute an action, and does not directly control the invocation of the action.
79+
80+
The following table describes the available settings.
81+
82+
|Value|Description|
83+
|-----------|-----------------|
84+
|Batch|The action should run as part of a batch operation or an [!INCLUDE[ssISnoversion](../../includes/ssisnoversion-md.md)] task.|
85+
|Interactive|The action runs when the user invokes the action.|
86+
|On Open|The action runs when the cube is first opened.|
87+
88+
**Application**
89+
Type the name of the application that can interpret the string returned by **Action expression**.
90+
91+
You can also use this option to identify which client application most commonly uses this action, as well as to display appropriate icons next to the action in a pop-up menu.
92+
93+
> [!NOTE]
94+
> This option only provides a recommendation to a client application as to what client application should execute an action, and does not directly control access to the action. Client applications should hide any actions that are associated with other client applications.
95+
96+
**Description**
97+
Type the optional description of the action.
98+
99+
**Caption**
100+
Type the caption to be displayed for the action in the client application if **Caption Is MDX** is set to **False**.
101+
102+
Type the Multidimensional Expressions (MDX) expression that returns a string for the caption if **Caption Is MDX** is set to **True**.
103+
104+
**Caption is MDX**
105+
Select **False** to indicate that **Caption** contains a literal string representing a caption to be displayed for the action in the client application.
106+
107+
Select **True** to indicate that **Caption** contains an MDX expression that returns a string representing a caption to be displayed for the action in the client application. The MDX expression must be resolved before the action is returned to the client application.
108+
109+
## See Also
110+
[Actions &#40;Cube Designer&#41; &#40;Analysis Services - Multidimensional Data&#41;](../../2014/analysis-services/actions-cube-designer-analysis-services-multidimensional-data.md)
111+
[Toolbar &#40;Actions Tab, Cube Designer&#41; &#40;Analysis Services - Multidimensional Data&#41;](../../2014/analysis-services/toolbar-actions-tab-cube-designer-analysis-services-multidimensional-data.md)
112+
[Action Organizer &#40;Actions Tab, Cube Designer&#41; &#40;Analysis Services - Multidimensional Data&#41;](../../2014/analysis-services/action-organizer-cube-designer-analysis-services-multidimensional-data.md)
113+
[Calculation Tools &#40;Actions Tab, Cube Designer&#41; &#40;Analysis Services - Multidimensional Data&#41;](../../2014/analysis-services/calculation-tools-actions-cube-designer-analysis-services-multidimensional-data.md)
114+
[Drillthrough Action Form Editor &#40;Actions Tab, Cube Designer&#41; &#40;Analysis Services - Multidimensional Data&#41;](../../2014/analysis-services/drillthrough-action-form-editor-cube-designer-analysis-services-multidimensional-data.md)
115+
[Report Action Form Editor &#40;Actions Tab, Cube Designer&#41; &#40;Analysis Services - Multidimensional Data&#41;](../../2014/analysis-services/report-action-form-editor-cube-designer-analysis-services-multidimensional-data.md)
116+
117+

‎docs/2014/analysis-services/action-organizer-cube-designer-analysis-services-multidimensional-data.md‎

Lines changed: 47 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,47 @@
1+
---
2+
title: "Action Organizer (Actions Tab, Cube Designer) (Analysis Services - Multidimensional Data) | Microsoft Docs"
3+
ms.custom: ""
4+
ms.date: "06/13/2017"
5+
ms.prod: "sql-server-2014"
6+
ms.reviewer: ""
7+
ms.suite: ""
8+
ms.technology:
9+
- "analysis-services"
10+
ms.tgt_pltfrm: ""
11+
ms.topic: "article"
12+
f1_keywords:
13+
- "sql12.asvs.cubeeditor.actionsview.organizerpane.f1"
14+
ms.assetid: 147b4622-e9fa-4537-9dbb-9e595c0f55bc
15+
caps.latest.revision: 24
16+
author: "Minewiskan"
17+
ms.author: "owend"
18+
manager: "mblythe"
19+
---
20+
# Action Organizer (Actions Tab, Cube Designer) (Analysis Services - Multidimensional Data)
21+
Use the **Action Organizer** pane on the **Actions** tab in Cube Designer to access the actions contained in the specified cube.
22+
23+
## Options
24+
**List**
25+
Displays the name of the action.
26+
27+
Select an action to display the **Action Form Editor**, a drillthrough action to display the **Drillthrough Action Form Editor**, or a report action to display the **Report Action Form Editor**.
28+
29+
## Context Menu
30+
The following options are available in the context menu, displayed by right-clicking an action in the **Action Organizer** pane:
31+
32+
**New Action**
33+
Click to display the **Action Form Editor** pane and create a new action.
34+
35+
**New Drillthrough Action**
36+
Click to display the **Drillthrough Action Form Editor** and create a new drillthrough action.
37+
38+
**New Reporting Action**
39+
Click to display the **Report Action Form Editor** and create a new report action.
40+
41+
**Delete**
42+
Click to display the **Delete Objects** dialog box and delete the selected action.
43+
44+
> [!NOTE]
45+
> This option is enabled only if the **Action Organizer** pane is selected.
46+
47+

0 commit comments

Comments
 (0)