Still a bit confused with your original MDX working as you were basing a lookup to }ElementAttributes_Month using members from Month.
Anyway, a few things to consider:
When using ORDER, ASC and BASC are for different cases where BASC breaks down any hierarchies before sorting, ASC sorts within hierarchies.
Attributes are always seen as strings i.e. sorting will be alphabetical 1, 10, 11..28, 29, 3, 30, 31..
Ideally you want to convert the strings to numerics to sort numerically but there is a gotcha where an attribute is blank, you need to trap this and assign a value.
As yet another alternative, you could try this:
Code: Select all
ORDER(
{TM1FILTERBYLEVEL({TM1SUBSETALL( [Month].[Month] )},0)},
VAL(
IIF([Month].[Month].CurrentMember.Properties("Seq No")="",
"9999" /* Default Value */,
[Month].[Month].CurrentMember.Properties("Seq No")
)
)
), BASC)