I am using analysis services 2005 with the MS suite as my front end.

Is there anyway to extract the row/column labels from a the cube? What I need to is process the "row" differently depending on the row label.

        Heading1  Heading2  Heading3   CalcResult
row1       14          12       10           .85
row2       65          89       25           .38
What I am trying to represent is that in the case of row1 I divide heading3 by heading1 but for row2 I divide heading3 by heading2.

Questions, inquires and general advice are all accepted.