Is it possible to add a manual column to make debugging MDX query results easier? For example, something like:
SELECT {
DESCENDANTS(...),
" --- end of descendants ---",
ASCENDANTS(...)
} ON ROWS
Yes you can, calulated members are the way. Take a look at the sample below where i have printed the current member, last member and next member
with member measures.CurrentName
as
[Product].[Product Line].currentmember.name
member measures.NextName
as
[Product].[Product Line].currentmember.nextmember.name
member measures.LastName
as
[Product].[Product Line].currentmember.prevmember.name
select {[Measures].[Internet Order Count],measures.CurrentName,measures.NextName,measures.LastName }
on 0,
[Product].[Product Line].[Product Line] on 1
from [Adventure Works]
Based on the comment below about adding a row
Here is a sample that adds row too.
with member measures.CurrentName
as
[Product].[Product Line].currentmember.name
member measures.NextName
as
[Product].[Product Line].currentmember.nextmember.name
member [Product].[Product Line].[CustomValue]
as
"End of descendants"
member measures.LastName
as
[Product].[Product Line].currentmember.prevmember.name
select {[Measures].[Internet Order Count],measures.CurrentName,measures.NextName,measures.LastName }
on 0,
{[Product].[Product Line].[Product Line],[Product].[Product Line].[CustomValue]} on 1
from [Adventure Works]