Unanswered: Cube question from cube newb(ie)
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.
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.
Heading1 Heading2 Heading3 CalcResult
row1 14 12 10 .85
row2 65 89 25 .38
Questions, inquires and general advice are all accepted.
Liv'n down on the cube farm. Left, then another left, then right.