如何在 MDX 中找出度量的数据类型? [英] How can I find out the datatype of measures in MDX?

问题描述

我是 Microsoft SQL Server Analysis Services 和 MDX 的新手.

I am new to Microsoft SQL Server Analysis Services and MDX.

如何在 MDX 中找出度量的数据类型?

How can I find out the datatype of measures in MDX?

我试图为其查找数据类型的度量是使用 WITH 子句定义的，据我了解，这意味着每个度量可能具有多种数据类型.

The measures I am trying to find the datatype for are defined using a WITH clause which as I understand means that it is possible for each measure to have multiple datatypes.

推荐答案

TypeName 函数怎么样:

How about the TypeName function:

WITH
Member [Measures].[My Type] as
TypeName([Measures].[My Other Measure])

等等...

您是正确的，每个单元格都可以是不同类型的您有一个计算.

You are correct that each cell can be a different type of you have a calculations.

这篇关于如何在 MDX 中找出度量的数据类型?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！