社区
数据仓库
帖子详情
ADOMD如何取出维度里某一层的成员属性?
chinabs
2002-10-22 03:32:02
ADOMD如何取出维度里某一层的成员属性?
...全文
38
1
打赏
收藏
ADOMD如何取出维度里某一层的成员属性?
ADOMD如何取出维度里某一层的成员属性?
复制链接
扫一扫
分享
转发到动态
举报
写回复
配置赞助广告
用AI写文章
1 条
回复
切换为时间正序
请发表友善的回复…
发表回复
打赏红包
whasdf
2002-10-23
打赏
举报
回复
我不知道ADOMD中怎么取,我只会这样
查MSDN中的帮助:openschema
VB代码(最好看明白帮助再用):
Dim cn As ADODB.Connection
Dim rs As ADODB.Recordset
Dim szPropertyName As String
Const PropertyName = "PROPERTY_NAME"
Set cn = New ADODB.Connection
cn.Open ("provider=msolap; Data Source=LocalHost; Initial Catalog=FoodMart 2000;")
Set rs = cn.OpenSchema(adSchemaProperties, Array("FoodMart 2000", Empty, Empty))
Do Until rs.EOF
szPropertyName = rs.Fields(PropertyName).value
Debug.Print szPropertyName
rs.MoveNext
Loop
你知道ADOMD如何取的话,望告知,谢谢
ADO
MD
程序员参考手册
ADO
MD
程序员参考手册
ADO
MD
程序员参考手册
计算机词汇
计算机词汇PDF,加强基础知识.
Microsoft SQL Server 2008 Analysis Services Unleashed
Contents at a Glance Introduction....................................................................................................1 Part 1: Introduction to Analysis Services 1 Introduction to OLAP and Its Role in Business Intelligence.........................7 2 Multidimensional Space...............................................................................17 3 Client/Server Architecture and Multidimensional Databases: An Overview27 Part 2: Creating Multidimensional Models 4 Conceptual Data Model................................................................................37 5 Dimensions in the Conceptual Model.........................................................43 6 Cubes and Multidimensional Analysis.........................................................63 7 Measures and Multidimensional Analysis....................................................75 8 Advanced Modeling......................................................................................91 9 Multidimensional Models and Business Intelligence Development Studio...................................................................................109 Part 3 Using
MD
X To Analyze Data 10
MD
X Concepts............................................................................................139 11 Advanced
MD
X...........................................................................................161 12 Cube-Based
MD
X Calculations...................................................................189 13 Dimension-Based
MD
X Calculations.........................................................221 14 Extending
MD
X with Stored Procedures....................................................237 15 Key Performance Indicators, Actions, and the DRILLTHROUGH Statement.......................................................................261 16 Writing Data into Analysis Services...........................................................291 Part 4 Creating a Data Warehouse 17 Loading Data from a Relational Database..................................................307 18 DSVs and Object Bindings..........................................................................317 19 Multidimensional Models and Relational Database Schemas...................329Part 5 Bringing Data into Analysis Services 20 The Physical Data Model............................................................................345 21 Dimension and Partition Processing..........................................................377 22 Using SQL Server Integration Services to Load Data.................................407 23 Aggregation Design and Usage-Based Optimization..................................417 24 Proactive Caching and Real-Time Updates................................................435 25 Building Scalable Analysis Services Applications.......................................451 Part 6 Analysis Server Architecture 26 Server Architecture and Command Execution...........................................477 27 Memory Management................................................................................503 28 Thread Management...................................................................................521 29 Architecture of Query Execution—Calculating
MD
X Expressions............527 30 Architecture of Query Execution—Retrieving Data from Storage.............553 Part 7 Accessing Data in Analysis Services 31 Client/Server Architecture and Data Access...............................................569 32 XML for Analysis........................................................................................579 33
ADO
MD
.NET...............................................................................................599 34 Analysis Management Objects....................................................................669 Part 8 Security 35 Security Model for Analysis Services..........................................................713 36 Securing Dimension Data...........................................................................731 37 Securing Cell Values....................................................................................751 Part 9 Management 38 Using Trace to Monitor and Audit Analysis Services.................................763 39 Backup and Restore Operations..................................................................787 40 Deployment Strategies................................................................................805 41 Resource Monitoring...................................................................................815 Index...........................................................................................................823
计算机英语(txt)电子版
计算机英语(txt)电子版,经过分类整理
ADO
MD
.NET及其相关API介绍
与
ADO
.NET类似,
ADO
MD
.NET也提供了一系列API用于访问多维数据集。不过与
ADO
.NET不同的是
ADO
MD
.NET是通过
MD
X查询来获取数据集,而通过
MD
X查询得到的数据集与普通数据集不同,通过
MD
X得到的是多维数据集,是CellSet类的一个对象,而非DataSet。
ADO
MD
.NET中同样有Connection、Command、等这些在
ADO
.NET中常见的
数据仓库
7,394
社区成员
6,741
社区内容
发帖
与我相关
我的任务
数据仓库
其他数据库开发 数据仓库
复制链接
扫一扫
分享
社区描述
其他数据库开发 数据仓库
社区管理员
加入社区
获取链接或二维码
近7日
近30日
至今
加载中
查看更多榜单
社区公告
暂无公告
试试用AI创作助手写篇文章吧
+ 用AI写文章