How can I expand a particular level of dimension from a pivot table. Currently when I select a particular dimension, all other dimensions on the same level also expand which causes long processing time. Need advise please. Thank you
如何从pivot表扩展特定的维度级别。目前，当我选择一个特定的维度时，同一级别上的所有其他维度也会扩展，从而导致长时间的处理。需要请告知。谢谢你！
1 个解决方案
#1
1
I've searched for this solution forever with no luck.
我一直在寻找这个解决办法，但运气不好。
Since you must be connecting directly to the cube, you would have to create unique fields in your Dimension table so that they can be expanded/collapsed properly. I've had to use this as a work around for management reporting. It's obviously not the best option storing more data in your table.
由于必须直接连接到多维数据集，因此必须在维度表中创建惟一的字段，以便能够正确地展开/折叠它们。我不得不把这个作为管理报告的工作。显然，在表中存储更多数据不是最好的选择。
#1
1
I've searched for this solution forever with no luck.
我一直在寻找这个解决办法，但运气不好。
Since you must be connecting directly to the cube, you would have to create unique fields in your Dimension table so that they can be expanded/collapsed properly. I've had to use this as a work around for management reporting. It's obviously not the best option storing more data in your table.
由于必须直接连接到多维数据集，因此必须在维度表中创建惟一的字段，以便能够正确地展开/折叠它们。我不得不把这个作为管理报告的工作。显然，在表中存储更多数据不是最好的选择。