I have created a custom extension that allows the user to dynamically populate a pivot table with dimensions and meaures, selected from a list.
Everything is fine upon creating and changing selections.
However, whenever a user needs to move a left dimension to a top dimension and then make changes to the dimensions and/or measures, the positions reset to their original sources(i.e dimensions return to the left, measures return to the top)
I am trying to figure out the "pseudo-dimension" logic and the qInterColumnSortOrder in the qHyperCubeDef that is being returned
I've read the documentation several times but still don't understand the logic behind it.