Version 6.3 Packaging

Two CDs:

1.       Microsoft ProClarity Analytics Server CD:   Analytics Server, Dashboard Server, Business Logic Server and Web Professional

2.       Microsoft ProClarity Desktop Professional CD:  Desktop Professional

Windows Service应用程序是一种需要长期运行的应用程序，它没有用户界面，并且也不会产生任何可视化的输出（任何用户消息都会被写入Windows事件日志或者其它自定义的日志中）。因此，它特别适合于服务器环境。在计算机启动时，Windows Service就会自动开始运行（需要设置服务类型为Automatic），它们不需要用户一定登录才行。

Build Automation Management是为了标准化企业的自动化编译过程。通过Windows Service与MSBuild的结合实现企业的Automation Build。Build Automation Management可以处理scheduled  Build,也可以处理unscheduled build。

创建Windows Service

将Windows Service的Account设置为User。其它账户可能无权使用Proces。

在Windows Service中添加Build Code。

MSBuild.exe位于%SystemRoot%\Micorsoft .NET\Framework\V2.0.502727目录下。因此，获取该目录所谓的绝对路径。

   string systemRoot = Path.GetDirectoryName(Environment.SystemDirectory);

            string FrameworkPath = systemRoot + @"\Microsoft.NET\Framework";

            if (!Directory.Exists(FrameworkPath))

            {

                throw new DirectoryNotFoundException("The framework directory could not be located.");

            }

            string msBuildDir = FrameworkPath + @"\v2.0.50727";   

获得所需要编译的设置选项。例如，需要编译Debug和Release两个版本。并将这些选项存放在一个临时变量中。    

            string[] configs = new string[] { "Debug", "Release", };    

获得项目路径并调用MSBuild进行编译。

            string projectPath = @"e:\temp\test\test.sln";

            eventLog1.WriteEntry("Start Build");

            foreach (string str in configs)

            {

                Process process = new Process();

                process.StartInfo.FileName = msBuildDir + @"\msbuild.exe";

                process.StartInfo.Arguments = projectPath + @" /p:Configuration=" + str + "\"";

                Console.WriteLine(process.StartInfo.Arguments);

                process.Start();

            }       
完整代码如下：

  string systemRoot = Path.GetDirectoryName(Environment.SystemDirectory);
            string FrameworkPath = systemRoot + @"\Microsoft.NET\Framework";
            if (!Directory.Exists(FrameworkPath))
            {
                throw new DirectoryNotFoundException("The framework directory could not be located.");
            }
            string msBuildDir = FrameworkPath + @"\v2.0.50727";         
            string[] configs = new string[] { "Debug", "Release};        
            string projectPath = @"e:\temp\test\test.sln";
            eventLog1.WriteEntry("Start Build");
            foreach (string str in configs)
            {
                Process process = new Process();
                process.StartInfo.FileName = msBuildDir + @"\msbuild.exe";
                process.StartInfo.Arguments = projectPath + @" /p:Configuration=" + str + "\"";
                Console.WriteLine(process.StartInfo.Arguments);
                process.Start();
            }        

2   使用MSFlexGrid显示多维数据集合
        private void DisplayCellSet(CellSet cs)
        {
             cellSetGrid.Redraw = false;
            try
            {
                cellSetGrid.Clear();
                AxisCollection axes = cs.Axes;    //获取轴的集合
                int axesCount = axes.Count;
                if (axesCount > 2)
                    throw new Exception("This sample application do not support ");
                Set columns = null;
                Set rows = null;

                int columncount = 0;
                int rowcount = 1;

                int fixedColumnCount = 0;   
                int fixedRowCount = 0;

                int gridRow = 0;
                int gridColumn = 0;

                if (axesCount > 0)
                {
                    columns = axes[0].Set;
                    columncount = columns.Tuples.Count;
                    fixedRowCount += columns.Hierarchies.Count;     //固定行的个数
                }

                if (axesCount > 1)
                {
                    rows = axes[1].Set;
                    rowcount = rows.Tuples.Count;
                    fixedColumnCount += rows.Hierarchies.Count;   //固定列的个数
                }

                cellSetGrid.Cols = fixedColumnCount + columncount;       //设置控件的列数
                cellSetGrid.FixedCols = fixedColumnCount;                      //设置控件的固定的列数

                cellSetGrid.Rows = fixedRowCount + rowcount;        //设置控件的行数
                cellSetGrid.FixedRows = fixedRowCount;                  //设置控件的可变的

                gridColumn = fixedColumnCount;

                //添加列标题
                foreach (Tuple tuple in columns.Tuples)
                {
                    gridRow = 0;
                    foreach (Member member in tuple.Members)
                    {
                        cellSetGrid.set_TextMatrix(gridRow, gridColumn, member.Caption);
                        gridRow++;
                      //  cellSetGrid.set_ColWidth(1, 2000);
                    }
                    gridColumn++;

                }

                //添加行标题
                if (rows != null)
                {
                    gridRow = fixedRowCount;
                    foreach (Tuple tuple in rows.Tuples)
                    {
                       
                        gridColumn = 0;
                        foreach (Member member in tuple.Members)
                        {
                            cellSetGrid.set_TextMatrix(gridRow, gridColumn, member.Caption);
                            gridColumn++;
                        }
                        gridRow++;
                    }

                }
                
                //填充数据

                int iCell = 0;
                for (gridRow = fixedRowCount; gridRow < cellSetGrid.Rows; gridRow++)
                {
                    for (gridColumn = fixedColumnCount; gridColumn < cellSetGrid.Cols; gridColumn++)
                    {
                        if (cs.Cells[iCell].Value != null)
                        {
                            cellSetGrid.set_TextMatrix(gridRow, gridColumn, cs.Cells[iCell].Value.ToString());

                        }
                        iCell++;
                    }
                }

                //设置列宽
                int maxwidth = 0;
                for (gridColumn = 0; gridColumn < cellSetGrid.Cols; gridColumn++)
                {
                    for (gridRow = 0; gridRow < cellSetGrid.Rows; gridRow++)
                    {
                        int actualWidth = cellSetGrid.get_TextMatrix(gridRow, gridColumn).Length * 100;
                        if (actualWidth > maxwidth)
                            maxwidth = actualWidth;
                    }
                    cellSetGrid.set_ColWidth(gridColumn, maxwidth);
                }

            }
            catch(Exception err)
            {
                MessageBox.Show(err.Message);
            }
            finally
            {
                cellSetGrid.Redraw = true;
            }
          
        }
        程序执行结果如下图所示：
        
         
          文件下载路径：
            http://www.cnblogs.com/Files/sorosjing/CellGridDemo.rar

                BusinessSpaceConfiguration bsconfigData = new BusinessSpaceConfiguration();
                bsconfigData.FileName = "def.txt";
                System.Configuration.Configuration config1 = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None);
                config1.Sections.Remove("BusinessSpaceConfiguration");
                config1.Sections.Add("BusinessSpaceConfiguration", bsconfigData);
                config1.Save();                      
            }
            catch (Exception err)
            {
                Console.Write(err.Message);
            }
        }

3  生成的配置文件格式如下所示：
<?xml version="1.0" encoding="utf-8"?>
<configuration>
    <configSections>
        <section name="BusinessSpaceConfiguration" type="ConsoleApplication1.BusinessSpaceConfiguration, ConsoleApplication1, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null" />
        <section name="ConfigurationSections" type="ConsoleApplication1.ConfigurationSections, ConsoleApplication1, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null" />
    </configSections>
    <BusinessSpaceConfiguration filename="def.txt" />
    <ConfigurationSections filename="abc.txt" />
</configuration>

3  读取应用程序配置文件
   private static void ReadAppConfiguration()
        {
            ConfigurationSections obj1 = ConfigurationManager.GetSection("ConfigurationSections") as ConfigurationSections;
            BusinessSpaceConfiguration obj2 = ConfigurationManager.GetSection("BusinessSpaceConfiguration") as BusinessSpaceConfiguration;
            Console.WriteLine(obj1.FileName);
            Console.WriteLine(obj2.FileName);

        }

• The number of axes (up to 128)
• The members from each dimension to include on each axis
• The name of the cube that sets the context
• The members from a slicer dimension on which data is sliced for members from the axis dimensions

This information can be complex. MDX syntax provides the information in a simple and straightforward manner, using the MDX SELECT statement.

Basic MDX Syntax: SELECT Statement

In MDX, the SELECT statement is used to specify a dataset that contains a subset of multidimensional data. A basic MDX query is structured in the following way:

SELECT [<axis_specification>
       [, <axis_specification>...]]
  FROM [<cube_specification>]
[WHERE [<slicer_specification>]]

The basic MDX SELECT statement contains a SELECT clause and a FROM clause, with an optional WHERE clause. These syntax elements are shown in the following example:

SELECT
   { [Measures].[Unit Sales], [Measures].[Store Sales] } ON COLUMNS,
   { [Time].[1997], [Time].[1998] } ON ROWS
FROM Sales
WHERE ( [Store].[USA].[CA] )

The SELECT clause determines the axis dimensions of an MDX SELECT statement. Two axis dimensions are defined in this MDX query example.The FROM clause determines which multidimensional data source is to be used when extracting data to populate the result set of the MDX SELECT statement.

A WHERE clause optionally determines which dimension or member to use as a slicer dimension; this restricts the extracting of data to a specific dimension or member. The WHERE clause in this example restricts the data extract for the axis dimensions to a specific member of the Store dimension. An MDX SELECT statement supports other optional syntax elements, such as the WITH keyword, and the use of MDX functions to construct members by calculation for inclusion in an axis or slicer dimension.

SQL and MDX

The syntax format of the MDX SELECT statement is similar to that of SQL syntax; however, there are several primary differences:

• MDX syntax distinguishes sets by surrounding tuples or members with braces (the { and } characters.) MDX queries can have up to 128 axis dimensions in the SELECT statement, but only the first 5 axes have aliases. An axis can be referred to either by its ordinal position within an MDX query, or by its alias if it has been assigned an alias. In the previous example, the COLUMNS and ROWS axis aliases are used. The example query could also have been written in the following way, using the ordinal position of each axis:

• SELECT
     { [Measures].[Unit Sales], [Measures].[Store Sales] } ON AXIS(0),
     { [Time].[1997], [Time].[1998] } ON AXIS(1)
  FROM Sales
  WHERE ( [Store].[USA].[CA] )

• As with an SQL query, the FROM clause names the source of the data for the MDX query. However, unlike an SQL query, the FROM clause in an MDX query is restricted to a single cube. Information from other cubes can be retrieved, however, on a value-by-value basis using the LookupCube function.
• In the MDX query, the WHERE clause describes the slicer dimensions. If a dimension is not mentioned as part of the WHERE clause, Microsoft SQL Server 2000 Analysis Services assumes that any dimension not assigned to an axis dimension is a slicer dimension, and the dimension is filtered on its default members. The WHERE clause can change the filtering process for specified dimensions, allowing fine control of included data.