Microsoft SQL Server Product Samples: Analysis Services

Source code checked in, #29248

bonniefe — Wed, 04 Nov 2009 05:40:54 GMT

Create release branch for KJ CTP3 (November).

Source code checked in, #29091

bonniefe — Tue, 20 Oct 2009 22:46:07 GMT

Create KJ trunk

Source code checked in, #29090

bonniefe — Tue, 20 Oct 2009 22:43:00 GMT

Created Release: SQL Server 2008 SR3 (Oct 06, 2009)

bonniefe — Tue, 06 Oct 2009 21:39:50 GMT

Microsoft SQL Server 2008 (October 2009) Samples Refresh 3

This release is dedicated to the samples that ship for Microsoft SQL Server 2008.

For many of these samples you will also need to download the AdventureWorks family of databases.

Released: SQL Server 2008 SR3 (Oct 06, 2009)

Tue, 06 Oct 2009 21:39:50 GMT

Microsoft SQL Server 2008 (October 2009) Samples Refresh 3

This release is dedicated to the samples that ship for Microsoft SQL Server 2008.

For many of these samples you will also need to download the AdventureWorks family of databases.

Source code checked in, #28823

leilu — Thu, 24 Sep 2009 07:52:25 GMT

Source code checked in, #28815

bonniefe — Wed, 23 Sep 2009 02:24:06 GMT

Branch for SQL Server 2008 Samples Refresh 3.

New Comment on "SS2005!Activity Viewer"

brucenan — Fri, 28 Aug 2009 08:35:38 GMT

Why program want to load a XML from "C:\documents and settings\Microsoft\Microsoft SQL Server\90\Tools\Shell\RegSrvr.xml", But I can not find this file in my machine. How can I run this program sucessfully?

New Comment on "SS2008!Readme_AMOAdventureWorks"

jcolaizzi — Fri, 14 Aug 2009 00:33:48 GMT

I'm working with Visual Studio 2005 or 2008 and the AmoAdventureWorks sample and Sql Server 2008 Standard edition. I've made two changes to the AmoAdventureworks project, both in Program.cs. First I put an immediate return in the CreateCurrencyRatesMeasureGroup method to avoid the issue of semiadditive measures not being available in the Standard Edition. Second in the CreateRolesAndPermissions method for the reader role I used this statement: role.Members.Add(new RoleMember("EIT\test1")); // e.g. redmond\johndoe instead of: role.Members.Add(new RoleMember("")); // e.g. redmond\johndoe and then role.Update(); gets this exception: {"The following system error occurred: No mapping between account names and security IDs was done. .\n"} If I use this statement: role.Members.Add(new RoleMember("EIT\test1", "S-1-5-21-107385321-1855232891-3196306309-513")); // e.g. redmond\johndoe it runs to completion and creates the cube. That is a valid user\sid combination in our domain and as a Server Admin in Analysis Services I can browse the cube. However if I go into SSMS 2008 and open the AmoAdventureWorks AS database, then open roles and right click on Readers -> Properties -> Membership it shows S-1-5-21-107385321-1855232891-3196306309-513 as the user for this role. If I add a user and immediately remove that user and click ok I once again get a dialog box with: The following system error occurred: No mapping between account names and security IDs was done. Will someone please explain what I'm doing wrong or missing here? Thanks

Closed Issue: Simple Sample ADOMD ClientAccess: There is an exception when click the head of datagrid.

libinzhao — Wed, 29 Jul 2009 03:44:28 GMT

Environment:
====================
1. Win2k3 x64 ENT ENU SP2.
2. VS2005
3. Katmai Samples 81016

Steps:
====================
1. Deployed the AdventureWorks Analysis Services Project to localhost server.
2. Build and run the Simple Sample ADOMD ClientAccess.exe.
3. click the “Connect to Server and explore maid objects”.
4. Select the “AdventureWorks DW” of available databases.
5. Click the “Run Query” button.
6. Click the “[Measures].[Reseller Sales Amount]” of the datagrid head.

Expectation:
===================
The Simple Sample ADOMD ClientAccess.exe can work without exception.

Actual Results:
===================
There is an exception message box popup. please see the attached picture exception.jpg for detail.
Comments: Verify on sample 90727.

Closed Issue: AmoBrowser: There is an exception when click the AdventureWorksDW AS Database.

libinzhao — Wed, 29 Jul 2009 03:44:21 GMT

Closed Issue: Simple Sample ADOMD Client Access: Failed to receive the query result when click “Run query” at the second time.

libinzhao — Fri, 17 Jul 2009 05:24:03 GMT

This Defect also repros on Yukon RTM.
Environment:
=====================
1. Windows 2003 ENT ENU
2. Installed Yukon DEV ENU SP2 (9.00.3028), WR4 sample 61201
3.Installed Vistual Studio 2005.
4. Created AS database “Simple Sample” using “Simple Sample AMO Access”.

Steps:
=====================
1. Double click "Simple Sample ADOMD ClientAccess.exe" to run the application.
2. Click the button "Connect to Server and Explore Main Objects".
3. Click "Run query".
4. Click "Run query"

Expectation:
====================
The query result ofstep4 should bethe same asthose in step3.

Actual result:
====================
An unhandled exception "A column named '[Measures].[Reseller Sales Amount]' already belongs to this DataTable." occurs.

Comments:
====================
The following unhandled exception also occur when click "run query":
1. An unhandled exception "Query (2, 67) Analizador: La sintaxis de '[date]' es incorrecta." occurs when execute the following script in English platform:
SELECT
KPIValue("Internet Revenue") on columns,
[Date].[Date] on rows
FROM
[Adventure Works Simple Sample]
WHERE
$[date].[date]
2. An unhandled exception "'row' argument cannot be null." when run the following query:
SELECT
[Measures].[Average Rate] on columns,
[Date].[Date] on rows
FROM
Direct Sales
3. An unhandled exception "Specified argument was out of the range of valid values." occurs when run the following script.
SELECT
[Measures].[Reseller Sales Amount] on columns
FROM
Adventure Works Simple Sample
WHERE
[Customer].[Country-Region].&[United States]
Comments: Verify on sample 90714.

Commented Issue: Simple Sample ADOMD ClientAccess: There is an exception when click the “Sales Forecasting Model”.

leilu — Tue, 28 Apr 2009 09:25:08 GMT

Environment:
===============
1. Win2k3 SP2 X64
2.SQL Server 10.0.1600.22
3. SQL Samples 090306

Repro Steps:
===============
1>     Build the AS Simple sample solution Successfully.
2>     Run the Simple Sample AMO Access.exe from Step1 to step 6 to create the Simple Sample AS Database.
3>     Run the Simple Sample ADOMD ClientAccess.exe, Click the “ Connect to Server and Explore the Main Objects” Button.
4>     Check the Simple Sample from the Available Database List, Expand “ MiningStructures”.
5>     Expand “Forecasting Sale structure”.
6>     Expand “Model”, click the “Sales Forecasting Model”.

Expectation:
===============
The Simple Sample ADOMD ClientAccess.exe should run properly without any exception.

Actual Result:
===============
There is an exception when click the “Sales Forecasting Model”.
Please take a view the attached picture: ASSimpleException.bmp
Comments: Programmability\AMO\AS Simple Sample\CS\ClientAccess\Simple Sample ADOMD ClientAccess.cs
Modify Methods==>128
private void fillCellSet_Click(object sender, EventArgs e)
Modify Methods==>314
private void mdxResultsView_CellContentClick(object sender, DataGridViewCellEventArgs e)

Commented Issue: Simple Sample ADOMD ClientAccess: There is an exception when click the head of datagrid.

leilu — Tue, 28 Apr 2009 09:18:41 GMT

Commented Issue: Simple Sample ADOMD Client Access: Failed to receive the query result when click “Run query” at the second time.

leilu — Tue, 28 Apr 2009 09:17:19 GMT

Source code checked in, #27159

leilu — Tue, 28 Apr 2009 09:14:52 GMT

Commented Issue: AmoBrowser: There is an exception when click the AdventureWorksDW AS Database.

leilu — Tue, 28 Apr 2009 02:13:58 GMT

Environment:
===============
1. Win2k3 SP2 X64
2. SQL Server 10.0.1600.22
3. SQL Samples 090306

Repro Steps:
===============
1>     Deployed the AdventureWorks 2008 Analysis Services Project successfully.
2>     Build and run the AmoBrowser.exe
3>     Connect to the Local server, and expand the Databases.
4>     Click the Adventure Works DW 2008
5>     Click the DismissedValidationRules node.

Expectation:
===============
The AmoBrowser.exe should run properly without no exception.

Actual Result:
===============
At step5, there is an exception popped up, please take a view the attached picture AmobrowserError.bmp.
Comments: Programmability\AMO\AmoBrowser\CS\AmoBrowser\AMOBrowser.cs
Add Lines==>344
else if (collection is DismissedValidationResultCollection)
            {
                foreach (DismissedValidationResult dvr in collection)
                {
                    CreateNode(nodes, dvr.ValidationResult.SourcePath, dvr.ValidationResult);
                }
            }
            else if (collection is DismissedValidationRuleCollection)
            {
                foreach (DismissedValidationRule dvr in collection)
                {
                    CreateNode(nodes, dvr.ValidationRule.Description, dvr.ValidationRule);
                }
            }

Source code checked in, #27138

leilu — Tue, 28 Apr 2009 02:13:22 GMT

Closed Issue: ASPE: There are errors in readme file.

libinzhao — Tue, 21 Apr 2009 06:34:47 GMT

Environment:
======================
1.　Windows 2003 ENT ENU
2.　Katmai ENU 10.00.1019.09
3. Sample build 70509
4.　Whidbey 8.0.50727.42

Repro Steps:
======================
1. Open ReadMe.htm under “\Samples\Analysis Services\Programmability\Extensibility\”
2. Check the readme file.

Expectations:
======================
1. In the line before segment “Scenario”: Default location should be:
“C:\Program Files\Microsoft SQL Server\100\Samples\Analysis Services\Programmability\Extensibility\ASPE”

In segment “Building the Sample”:
2. Item 1, the description of “Open a Microsoft Visual Studio 2005 command prompt” should be:
“Click Start, point to All Programs, point to Microsoft Visual Studio 2005, point to visual Studio Tools, and then click Visual Studio 2005 Command Prompt”
3. Item 3, the command which generate strong key should be:
“sn -k ASPE.snk”
4. The build command should be:
“msbuild /nologo /verbosity:quiet /property:Configuration=Debug "ASPE.sln"”

In segment “Testing the Sample” – “To verify the context for user1”
5. Item 8: the expected folder under “Internet Sales” node should be “ISV_1/Common”
6. Item 9: there should be described as “Expand the ISV_1/Common folder, Notice that the Operations folder contains the Gross Internet Profit member.
7. Item 9: there should be description of “expand the Reseller Sales measure group, expand the ISV_1/Operations folder” in a newline.
8. Item 10: the folder under “Geography” dimension should be “ISV_1/Common” folder
9. Item 11: the folder under “Product” dimension should be “ISV_1/Operation”

In segment “Testing the Sample” – “To verify the context for user2”
10. Item 8: there should be described as “Expand the ISV_1/Common folder, Notice that the Gross Internet Profit member. For b of item 8, the folder name under “Exchange Rates” measure group should be “ISV_1/Finance”
11. Item 9: the folder under “Geography” dimension should be “ISV_1/Common” folder
12. Item 10: the folder under “Product” dimension should be “ISV_1/Finance”

In segment “Testing the Sample” – “To verify the context for user3”
13. Item 8: there should be described as “Expand the ISV_1/Common folder, Notice that the Gross Internet Profit member. For c of item 8, the folder name under “Reseller Orders” measure group should be “ISV_1/Marketing”
14. Item 9: the folder under “Geography” dimension should be “ISV_1/Common” folder
15. Item 10: the folder under “Product” dimension should be “ISV_1/Marketing”

Actual Results:
======================
1. “C:\Program Files\Microsoft SQL Server\100\Samples\Analysis Services\Administrator\ASPE”
2. “Click Start, point to All Programs, point to Microsoft .NET Framework SDK 2.0, and then click SDK Command Prompt."
3. “sn -k SampleKey.snk”
4. “msbuild /nologo /verbosity:quiet /property:Configuration=Debug "CS/ ASPE.sln”
5. “expand the ISV_1 folder, expand the Common folder
6. “Expand the ISV_1 folder, expand the Common folder, expand the Gross Internet Profit member”
7. “expand the Reseller Sales measure group, expand the ISV_1 folder, and then expand the Operations folder” in a newline.
8. “expand the ISV_1 folder, and then expand the Common folder”
9. “expand the ISV_1 folder, and then expand the Operations folder”
10. “expand the ISV_1 folder, expand the Common folder, expand the Gross Internet Profit member”
For b of item 8, it is “expand the ISV_1 folder, and then expand the Finance folder “
11. “expand the ISV_1 folder, and then expand the Common folder”
12. “expand the ISV_1 folder, and then expand the Finance folder”
13. “expand the ISV_1 folder, and then expand the Common folder, the Gross Internet Profit member”, for c of item 8, it is “expand the ISV_1 folder, and then expand the Marketing folder”
14. “expand the ISV_1 folder, and then expand the Common folder”
15. “expand the ISV_1 folder, and then expand the Marketing folder”

Comments:
======================
All the folder name of “ISV _1” in readme file is inconsistency with the folder name in database “Adventure Works DW” in
Environment:
======================
1.　Windows 2003 ENT ENU
2.　Katmai ENU 10.00.1019.09
3. Sample build 70509
4.　Whidbey 8.0.50727.42

Repro Steps:
======================
1. Open ReadMe.htm under “\Samples\Analysis Services\Programmability\Extensibility\”
2. Check the readme file.

Expectations:
======================

1. In segment “Building the Sample”, Item 1, the description of “Open a Microsoft Visual Studio 2005 command prompt” should be: “Click Start, point to All Programs, point to Microsoft Visual Studio 2005, point to visual Studio Tools, and then click Visual Studio 2005 Command Prompt”
2. In segment “Building the Sample”, Item 3, the command which generate strong key should be: “sn -k ASPE.snk”
3. In segment “Testing the Sample” – “To verify your context”，Item 8: Expand the Internet Sales node, and verify that should be no "ISV_1/Common” folder under this node.
4. In segment “Testing the Sample” – “To verify your context”，Item 9: Expand the Geography dimension, and verify that should be no "ISV_1/Common" folder in this dimension.
5. In segment “Testing the Sample” – “To verify your context”，Item10: Expand the Product dimension, and verify that should be no "ISV_1/Operations" folder in this dimension.
6. In segment “Testing the Sample” – “To verify the context for user1”, Item 9: the expected folder under “Internet Sales” node should be “ISV_1/Common”
7. In segment “Testing the Sample” – “To verify the context for user1”, Item 10: there should be described as “Expand the ISV_1/Common folder, Notice that the Operations folder contains the Gross Internet Profit member.
8. In segment “Testing the Sample” – “To verify the context for user1”, Item 11: there should be description of “expand the Reseller Sales measure group, expand the ISV_1/Operations folder” in a newline.
9. In segment “Testing the Sample” – “To verify the context for user1”, Item 12: the folder under “Geography” dimension should be “ISV_1/Common” folder
10. In segment “Testing the Sample” – “To verify the context for user1”,Item13: the folder under “Product” dimension should be “ISV_1/Operation”
11. In segment “Testing the Sample” – “To verify the context for user2”, Item 9: there should be described as “Expand the ISV_1/Common folder, Notice that the Gross Internet Profit member. For b of item 8, the folder name under “Exchange Rates” measure group should be “ISV_1/Finance”
12. In segment “Testing the Sample” – “To verify the context for user2”,Item12: the folder under “Geography” dimension should be “ISV_1/Common” folder
13. In segment “Testing the Sample” – “To verify the context for user2”,Item13: the folder under “Product” dimension should be “ISV_1/Finance”
14. In segment “Testing the Sample” – “To verify the context for user3”, Item 9: there should be described as “Expand the ISV_1/Common folder, Notice that the Gross Internet Profit member. For c of item 8, the folder name under “Reseller Orders” measure group should be “ISV_1/Marketing”
15. In segment “Testing the Sample” – “To verify the context for user3”,Item13: the folder under “Geography” dimension should be “ISV_1/Common” folder
16. In segment “Testing the Sample” – “To verify the context for user3”,Item14: the folder under “Product” dimension should be “ISV_1/Marketing”

Actual Results:
======================
1. “Click Start, point to All Programs, point to Microsoft .NET Framework SDK 2.0, and then click SDK Command Prompt."
2. “sn -k SampleKey.snk”
3. "Expand the Internet Sales node, and verify that there is no ISV_1 folder under this node"
4. "Expand the Geography dimension, and verify that there is no ISV_1 folder in this dimension"
5. "Expand the Product dimension, and verify that there is no ISV_1 folder in this dimension"
6. "expand the Internet Sales node to see the ISV_1 folder"
7. “Expand the ISV_1 folder, expand the Common folder, expand the Gross Internet Profit member”
8. “expand the Reseller Sales measure group, expand the ISV_1 folder, and then expand the Operations folder” in a newline.
9. “expand the ISV_1 folder, and then expand the Common folder”
10. “expand the ISV_1 folder, and then expand the Operations folder”
11. “expand the ISV_1 folder, expand the Common folder, expand the Gross Internet Profit member”
For b of item 8, it is “expand the ISV_1 folder, and then expand the Finance folder “
12. “expand the ISV_1 folder, and then expand the Common folder”
13. “expand the ISV_1 folder, and then expand the Finance folder”
14. “expand the ISV_1 folder, and then expand the Common folder, the Gross Internet Profit member”, for c of item 8, it is “expand the ISV_1 folder, and then expand the Marketing folder”
15. “expand the ISV_1 folder, and then expand the Common folder”
16. “expand the ISV_1 folder, and then expand the Marketing folder”

Comments:
======================
All the folder name of “ISV _1” in readme file is inconsistency with the folder name in database “Adventure Works DW” in SSMS.

Commented Issue: Simple Sample AMO Access: the partial class SimpleSampleAMOAccess is blank.

leilu — Mon, 20 Apr 2009 02:29:31 GMT

Environment:
====================
1. Win2k3 x64 ENT ENU SP2.
2. VS2005
3. Katmai Samples 81021

Steps:
====================
1. Open the solution file “..\Analysis Services\Programmability\AMO\AS Simple Sample\CS\ServerAdmin.sln" via vs2005.
2. Open the AMO add partition and xmla.cs of ServerAdmin project.
3. Check the content of this class.

Expectation:
===================
The partial class SimpleSampleAMOAccess should contains some source code.

Actual Results:
===================
It is a blank class which have nothing.

Comments:
====================
If the partial class SimpleSampleAMOAccess is unuseful or redundant, it should be removed.
Maybe user is confused that it isn't finished.
Comments: Remove File==>
Programmability\AMO\AS Simple Sample\CS\ServerAdmin\AMO add partition and xmla.cs