SSAS - 数据立方体层次结构在 Excel 中不可见 [英] SSAS - Data Cube Hierarchy not visible in Excel

问题描述

初始请求:在客户名称和产品描述上创建层次结构.

Initial Request: Create hierarchies over customer names and product descriptions.

问题:我创建了几个相似的层次结构，而产品描述层次结构在 Excel 中不可见

Problem: I created several similar hierarchies and the product description hierarchy is not visible in Excel

支持细节每个层次结构的计算列如下所示:

Supporting details The computed columns for each hierarchy look like this:

列名:产品描述前缀1表达式:

Column Name: Product Description Prefix1 Expression:

CASE 
WHEN [ProductDescription] = 'N/A' THEN 'N/A'
ELSE LEFT([ProductDescription], 1) 
END 

列名:产品描述前缀5表达式:

Column Name: Product Description Prefix5 Expression:

CASE 
WHEN [ProductDescription] = 'N/A' THEN 'N/A'
ELSE LEFT([ProductDescription], 5) 
END

列名:产品描述前缀10表达式:

Column Name: Product Description Prefix10 Expression:

CASE 
WHEN [ProductDescription] = 'N/A' THEN 'N/A'
ELSE LEFT([ProductDescription], 10) 
END

在我的产品维度中，我创建了一个分级的产品描述层次结构

In my product dimension, I created a Product Description Hierarchy that is leveled

• 产品描述前缀1
• 产品描述前缀5
• 产品描述前缀10
• 产品描述

1 是 5 的属性关系，5 是 10，10 是产品描述，产品描述是关键:产品.

With 1 being an attribute relationship to 5, 5 to 10, 10 to Product Description, and Product Description to the Key: Product.

这些属性中的每一个都设置了它们的 KeyColumn 集合:产品描述 Prefix1 的 KeyColumns:做自己产品说明 Prefix5 的 KeyColumns:1 和 5产品描述 Prefix10 的 KeyColumns: 1,5,10产品描述的 KeyColumns:1、5、10 和产品描述

Each one of these attributes have their KeyColumn collections are set: Product Description Prefix1's KeyColumns: Being its self Product Description Prefix5's KeyColumns: 1 and 5 Product Description Prefix10's KeyColumns: 1,5,10 Product Description's KeyColumns: 1,5,10, and Product Description

现在，我选择 AttributeHierarchyVisible = False 因为我不希望用户能够选择单个属性.

Right now, I'm choosing AttributeHierarchyVisible = False because I don't want the user to to be able to select the individual attribute.

对于我所缺少的导致层次结构变得可见的任何帮助将不胜感激

Any help as to what I am missing causing the hierarchy to become visible would be much appreciated

推荐答案

解决这个问题的方法在于计算列的命名.

The solution to this issue lies in the naming of the computed columns.

计算列的名称中有空格.

You have spaces in the names of the computed columns.

有了空格，数据就正确部署到了它应该有的地方；但是，Excel 2010 不会承认层次结构的存在——即使数据通过管理工作室可见.奇怪.

With the spaces, the data correctly deployed where it should have; however, Excel 2010 would not acknowledge the existence of a hierarchy -- even though the data was visible through management studio. Strange.

删除空间并部署多维数据集后，层次结构将可见.

Once the spaces are removed and the cube deployed, the hierarchy will be visible.

这篇关于SSAS - 数据立方体层次结构在 Excel 中不可见的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！