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
Post a Comment