0
votes

Is it possible for an Excel user to see the attributes of dimensions in any order he chooses after using DrillThroughAction (or something similar)? We currently have a cube where DrillThroughAction is defined, but VS won't let you set the same dimension again. All the attributes of the given dimension should be selected at once. (target server version 13)

Example as is:

Dim Account.Account ID
Dim Account.Account Type
Dim Customer.Customer Email
Dim Customer.Customer Country

An example as the user would like:

Dim Account.Account ID
Dim Customer.Customer Email
Dim Customer.Customer Country
Dim Account.Account Type

Is there any solution or workaround for this other than a dedicated report?