Hello Dennis,

The “Measures” object groups all of the measures and allows you to change the position where measures appear – rows or columns. Note that the “measures” object is the only one item with type of IMeasuleListViewModel so you can recognize it easily from the other items in the collection.

About the cube problem I’ll try to reproduce it and will write you back.

Thanks.
Plamen.

Hello Todor,

i just realized that the "Measure"-Object is also appearing in the Excel Pivotgrid. So using more than 1 Measure is indeed possible, i just have to ignore the "Measure"-Object when iterating over the header Columns.

So the cube problem is still remaining. I had 3 databases (A,B & C) that i could select in the XamPivotDataSelector. Each database contains one cube, but no cubes for the databases B&C appeared in the DataSelector after having selected these cubes. So i removed database A from the sql server. Now i can select the cube from database B, but the cube for database C is still missing in the DataSelector

Regards,

Dennis

.

Thanks Todor,

getting the MDX query would be helpful. However, i can generate it from the pivotgrids data.

I can drop more than one measure in the pivotgrid, but then an Object "Measures" appears in the Columns area.
What about the Cubes? I can select from several databases, but in total only one Cube is selectable.

I know how to get the members, but i need to get the dimension member properties. Again, i can get them by generating an MDX statement, but getting these properties from the pivotgrid would be nice.

Regards,

Dennis