SSAS 2016:在Excel 2013和Excel之间钻取不同的列顺序。 Excel 2016

问题描述:

亲爱的,

我在连接到SSAS 2016的两个Excel版本之间有不同的行为(表格):

I have a different behavior between 2 Excel versions connected to SSAS 2016 (Tabular) :

- 从Excel 2013中钻取:在钻取XL表格中,根据表格设计器中的表格模型对列进行排序

- Drill through from Excel 2013 : On the drill through XL sheet, columns are sorted according to the table model in the tabular designer

- 从Excel 2016钻取:在钻取XL表格中,列按字母顺序排序

- Drill through from Excel 2016 : On the drill through XL sheet, columns are sorted according to alphabetical order

我们的用户更喜欢XL 2013的行为。你已经遇到过这个问题吗?你知道SSAS或XL方面是否有补丁来解决这个问题吗?

Our user prefer the XL 2013 behavior. Have you already faced this issue ? Do you know if there is a patch either on SSAS or XL side to fix this issue ?

谢谢!

您好Tiptip00,

Hi Tiptip00,

根据我的测试,我发现它会运行良好(我在Excel 2016中测试,我目前没有Excel 2013)

Based on my test, I find that it will work well(I test this in Excel 2016, I didn't have Excel 2013 currently)

 我的excel版本如下所示

 My excel version is like below