InfoQ: How are those MDX queries generated?
InfoQ:这些MDX查询是如何生成的?
The simplified constructed MDX will then be sent to the data source to retrieve the fact data.
然后简化构建的MDX会被发送到数据源来检索事实数据。
Second, the fact that these servers implement XMLA means that they implement the MDX language.
第二,这些服务器实现XMLA实际上意味着他们要实现MDX语言。
Queries were built by calling an API, not specified textually in a language such as SQL or MDX.
查询需要调用API,而不是在SQL或MDX之类的语言里用文本的方式去指定。
Usage: This parameter controls the decision on when the NON EMPTY clause is applied to the query MDX.
用法:该参数控制何时向查询MDX应用NONempty子句的决策。
Can references in one MDX file link to a keyword in another MDX file?
MDX可以连接到属于另一个MDX文件里的关键字吗?
Trend is also normalized between -1 and 1, and also an MDX expression.
趋势也标准化为-1到1,并且也是一个MDX表达式。
The System is supporting MDX search, which make operation on multi-dimension data easier and more direct.
系统支持MDX(多维表达式)查询,对多个维度的数据的访问更为简单和直观。
This method relies on the underlying data source to process the entire MDX requests (minus some exceptions).
该方法依赖于基础数据源来处理整个MDX请求(除去一些例外情况)。
These include the density of a result set, size of a result set, amount of time taken to execute the MDX, etc.
这些包括一个结果集的密度、一个结果集的大小、执行MDX所需的时间,等等。
Nodes can be SQL execution nodes, MDX execution nodes, local processing nodes, decoration nodes, and many more.
节点可以是SQL执行节点、MDX 执行节点、本地处理节点、装饰节点(decoration nodes)等等。
The sets of allowed and denied members must be MDX expressions that evaluate to sets of members of the dimension.
允许和拒绝的成员组必须是MDX表达式,表达式的计算结果为该维度的成员组。
The XMDXSelect node is the node which will display the pieces of the actual MDX query used to satisfy the report request.
节点显示用于满足报表请求的实际MDX查询的部分。
Users can customize query through both MDX statements and graphic interface, and browse the result by way of tables or graphs.
用户不但可以直接写MDX语句或通过图形化界面定制查询,还可以通过多维视图控件以表格、图形等多种方式浏览查询结果。
The parsing process will convert the incoming V5 query spec and any potentially embedded SQL or MDX queries into a tree representation.
解析过程会将传入的V 5查询规范或任何潜在的嵌入式SQL或MDX查询转换成一个树表示。
With HResult the execution mode can combine MDX and XML in a single run tree, allowing for much higher flexibility and query performance.
通过 HResult,执行模式可以在单个运行树中结合MDX和XML,实现更高的灵活性和查询性能。
In this case, the formatting is actually based on a rule (MDX expression), setting different fill colors based on the value in each cell.
在这种情形中,格式实际上是基于一个规则(MDX表达式)的,基于每个单元格的数值设置不同的填充颜色。
Significant improvement for complex OLAP queries through intelligent combination of local and remote processing and better MDX generation.
通过将本地和远程处理与更好的MDX生成结合在一起可显著改善复杂的 OLAP查询。
It will then use the enumerated members to construct an MDX statement in order to retrieve the nested members with the measures requested.
然后它会使用枚举的成员构造一个mdx语句,以检索带有请求的度量的嵌套成员。
Status. A number defining the current status of the Value, normalized in the range -1 (very bad) to 1 (very good) - this is also an MDX expression.
现状。一个定义数值当前状态的数字,标准化为范围-1(非常差)到1(非常好)——这也是个MDX表达式。
The query transformations implement the logic that can transform an IBM Cognos query spec into a MDX query that a target data source can understand.
查询转换实现可将IBMCognos查询规范转化成MDX查询的逻辑,方便数据源理解。
Status. A number defining the current status of the Value, normalized in the range -1 (very bad) to + 1 (very good) - this is also an MDX expression.
现状。一个定义数值当前状态的数字,标准化为范围-1(非常差)到1(非常好)——这也是个MDX表达式。
The difference is that the query language is MDX, not SQL, and the result is a multidimensional CellSet, not a ResultSet consisting of rows and columns.
所不同的是,查询语言是MDX而非SQL,而且结果是个多维的CellSet,而不是由行和列组成的ResultSet。
In detail it includes the optimization of data source, cube, MDX and the adoption of multi-thread technique and the development of intelligent query division.
具体包括数据源、立方体和MDX的优化以及多线程技术的采用和查询智能拆分的开发。
This paper describes the design and the realization of data warehouse in customer relationship management system, and gives MDX operations in multidimensional data analysis.
论述了在客户关系管理系统中数据仓库的设计方案和具体实现方法。
These standards were simpler and because they were based upon a query language (MDX), were more like the APIs that developers were used to for talking to relational databases (ODBC, JDBC).
这些标准更加简单,而且由于基于查询语言MDX,它们更像开发人员用来和关系型数据库交互的API(ODBC、JDBC)。
Recall that the query model is a client-side library that generates MDX, so it is easy to change the query model without changing the core parts of the API for querying metadata and executing queries.
前面已经说过,查询模型是一个生成MDX的客户端库,所以修改起来非常容易,也不会修改API里查询元数据、执行查询的核心部分。
Recall that the query model is a client-side library that generates MDX, so it is easy to change the query model without changing the core parts of the API for querying metadata and executing queries.
前面已经说过,查询模型是一个生成MDX的客户端库,所以修改起来非常容易,也不会修改API里查询元数据、执行查询的核心部分。
应用推荐