I am trying to create a report from an adomd.net connection to a cube.

There is a time hierachy and a branch dimension in this cube. There are two measures: Clients and Orders. I am trying to create a scorecard with the 2 measures down the left hand side, which expand to list the branches. Across the top i would like a selection of the time dimension. This way I could look at the 4th branch column beneath Clients and see that in the first quarter of 2006 how many Clients I have. Is this possible?

I have attempted to do this by creating the two kpis (Clients and orders) and creating a scorecard with dimensionality.

If I add (some of) the time dimension to the column members and the branch dimension to row members (beneath scorecard hierachy) then the columns/rows look correct however the values in the cells are the number total number of clients or orders in each branch EVER, and duplicated for each time division along the top. The values are not being filtered by time division for each cell as they should be.

If I remove the branch from the row members list the values are correctly the total clients or policies in each time division.

Can anyone help me to achieve the desired result?

Thanks in advance!

Martin