会破坏OLAP多维数据集的字符列表 [英] A List of Characters That Will Break OLAP Cubes

问题描述

今天，我在一个正在处理的OLAP多维数据集中收到一个奇怪的错误.尝试从SSAS或从Excel中的外部连接访问它时，我收到类似于以下内容的错误:

Today I received a curious error in one of the OLAP cube I was working on. When trying to access it from SSAS or from a external connection in Excel, I received an error similar to what is described below:

''(十六进制值0x1A)是无效字符.第1行，位置 325042770.(System.Xml)

'', hexadecimal value 0x1A, is an invalid character. Line 1, position 325042770. (System.Xml)

不确定为什么将这个特殊字符显示为->"符号，但是在将错误消息导出到文本后，我确定这是.显然是"

Not sure why this special character was displayed as a "->" symbol, but after exporting the error message to text I determined this it was the "SUB" character. Apparently it was a "invalid character".

我很想"

I would love to "make sure that user hierarchy does not contain any invalid character.", however I don't know what the definition of that is, clearly you can't load the "SUB" character into a cube, however I'm not sure what other characters can or cannot be loaded in.

有

There are various claims being made about what is and is not allowed in cube dimension names, values, and descriptions. Overall however, when I look around the documentation seems very sparse, and there is not mention of the "SUB" character. In there a list of characters somewhere, or some sort of official (or non) documentation on this subject?

推荐答案

如果您仍然怀疑其中一个维度属性的数据存在问题，还可以尝试调整此InvalidXMLCharacters属性属性:

If you still suspect that there is an issue with the data of one of the dimension attributes, you can also try to tweak this InvalidXMLCharacters attribute property:

这篇关于会破坏OLAP多维数据集的字符列表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！