This project has moved. For the latest updates, please go here.
1
Vote

ExecuteDrillthroughAndFixColumns Enhancement for MDX queries

description

Furmangg,

I did Used the ExecuteDrillThroughAndFixColumns too. Here is my Rowset Action Expression .

'call ASSP.ExecuteDrillthroughAndFixColumns("'+
"select {[Measures].CurrentMember} On 0,
Non Empty (
[Dim Faculty].[First Name].[First Name].Members,
[Dim Faculty].[Last Name].[Last Name].Members
)
Having [Measures].[Enrollment Sum Count]>0 on 1
from (select (" + ASSP.CurrentCellAttributes([Measures].CurrentMember) + ") on 0 from [Test Cube])"+
'")'.

When I browse the cube in excel I get the First Column Header as [Member_Caption] and the next as[Dim Faculty].[Last Name].[Last Name].[Member_Caption]. Did I do something wrong or any thing missing so that my column headings are not as expected .Please help me to correct this .

Thanks!

comments