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

ASSP.CurrentCellAttributes() helper function on calculated members and column header fix?

Topics: Developer Forum, User Forum
Nov 21, 2014 at 10:43 PM
I am new to MDX and SSAS and wanted some information related to ASSP.CurrentCellAttributes() helper function , is there a way to use this function on calculated measures and also when i use this and drillthrough to my information my column headers are not getting fixed is there a way to do fix it ?

below is the code i am using......any help would be greatly appreciated.

"select {[Measures].CurrentMember} on Columns,
NON EMPTY
{
[Fact Trans Details].[TransID].Children *
[Fact Trans Details].[LinNo].Children*
[Time].[Time Period].Children*
}
ON ROWS

from (select (" + ASSP.CurrentCellAttributes([Measures].CurrentMember) + ") on 0 from [Cube])"
Coordinator
Nov 24, 2014 at 4:22 AM
ASSP.ExecuteDrillthroughAndFixColumns(DrillthroughMDX) is intended to fix column names of drillthrough queries, so as we discussed on email, it may not work for MDX queries. If you come up with a fix let us know.


The example for drillthrough query column names is here:

https://asstoredprocedures.codeplex.com/wikipage?title=Drillthrough&referringTitle=Home