Drilling through in ssas to a dimension attribute that has hierarchy disabled -


i using sql server 2008 r2, developing using bids. have large cube, many dimensions, , building drill through action. requirement broad drill through, includes many fields in fact table (and not used in cube, except in drill through), , many dimensions have attributes not hierarchy enabled such textual info.

i have created dimensions, , added attributes required drill through dimension attributes (i added fact dimension fields in fact table), , defined attributes used drill through attributehierarchyenabled = "false".

yet, when add drill through action, attributes hierarchy enabled appear in drop down while attributes having hierarchy disabled fail drill through action.

i wish avoid unnecessary hierarchies processing time getting extremely long, yet drill through requirement rigid.

please me on adding attribute has hierarchy disabled drill through?

thank you.


Comments