使用表格模型禁用的Excel数据透视表组选项

I'm having a lot of fun trying to solve this one.

我试着解决这个问题很有趣。

THE PROBLEM: We have two database 'cubes'. One is a multidimensional (old legacy cube) and one is a tabular model (new). We are trying to phase out the old multidimensional cube.

问题是:我们有两个数据库“多维数据集”。一个是多维(旧的遗留立方体)，一个是表格模型(新)。我们正在尝试逐步淘汰旧的多维数据集。

Client is using new tabular cube model with PivotTable. What she is trying to do is drag in COUNTY (text value) into rows, select multiple county values, right click and group counties into custom groups (ie. NORTH and SOUTH). This works with the old multidimensional cube but is grayed out for the new tabular cube. So much for the new hotness.

客户正在使用具有数据透视表的新表格立方体模型。她所要做的是将COUNTY(文本值)拖放到行中，选择多个COUNTY值，右键单击并将COUNTY分成自定义组。北部和南部)。这与旧的多维立方体一起工作，但为新的表格立方体变灰。这就是新时代的魅力所在。

FAILED SOLUTIONS:

失败的解决方案:

1. Confirmed problem is present on both Excel 2013 and 2016
2. Excel 2013和2016都存在确认问题
3. Checked for blank fields. There are no blank fields.
4. 检查空白领域。没有空白字段。
5. Tried with multiple fields and other tabular data cubes with same problem.
6. 尝试使用多个字段和其他有相同问题的表格数据立方体。
7. Changed formatting of cells to text.
8. 将单元格格式化为文本。
9. Read every posting I can find on this topic on the internet.
10. 阅读我能在网上找到的关于这个话题的每一篇文章。

If someone has a solution for this I would be so grateful.

如果有人能解决这个问题，我会非常感激。

1 个解决方案

#1

That's correct. That grouping feature uses "session cubes" which aren't supported in Tabular. Session cubes are actually a deprecated feature for Multidimensional and were never supported for Tabular.

这是正确的。该分组特性使用了表格中不支持的“会话多维数据集”。会话多维数据集实际上是多维的不赞成的特性，表中不支持会话多维数据集。

One workaround is to create an MDX calculated member following these instructions (see the What Are Calculated Members section) and use the formula:

一种解决方法是根据以下说明创建一个MDX计算成员(参见“计算成员”部分)，并使用公式:

Aggregate(
 {
  [County Dimension].[County].&[county 5456],
  [County Dimension].[County].&[county 5457]
 }
)