Đang chuẩn bị nút TẢI XUỐNG, xin hãy chờ
Tải xuống
Microsoft SQL Server 2005 Developer’s Guide- P21:This book is the successor to the SQL Server 2000 Developer’s Guide, which was extremely successful thanks to all of the supportive SQL Server developers who bought that edition of the book. Our first thanks go to all of the people who encouraged us to write another book about Microsoft’s incredible new relational database server: SQL Server 2005. | Chapter 11 Developing BI Applications with ADOMD.NET 419 The DataSource Class The DataSource class defines and interacts with the DataSources available in Analysis Services. The DataSourceView Class A DataSourceView contains a list of data pertinent to its underlying data source. The DataSourceView class is used to associate a data source with a data source view assign table schemas and save data source views to Analysis Services. The Dimension Class The Dimension class allows you to set the source of a dimension process the dimension and save the dimension to Analysis Services. Dimensions are essentially an additional layer of metadata you can place over a table or set of tables to define hierarchical relationships between columns. The Cube Class The Cube class allows you to set the source of a cube process the cube and the objects contained in the cube add MeasureGroups to a cube and save the cube and its contents to Analysis Services. Cubes store results of data at different summary levels resulting in efficient multidimensional query actions. ADOMD.NET Object Model ADOMD.NET data provider is a .NET Framework data provider that you can use to communicate with multidimensional data sources from a client application. AdomdConnection The AdomdConnection class is used to open a connection to a multidimensional data source. It can also be used to connect to the multidimensional data source metadata for example a local cube .cub file. You can review the local cube file to learn about the metadata properties that represent the cube on the multidimensional data source. Each AdomdConnection is associated with an XMLA session. The AdomdConnection objects are not automatically destroyed when they go out of scope. This means that you must explicitly close any open ADOMD.NET Connection objects in your applications. If the AdomdConnection is not closed it remains open and can be used by other AdomdConnections. AdomdCommand The AdomdCommand class is used to execute a command .
