Hi,
While trying to extract data from pivot-table that has more than one dimension I noticed that I receive only the measures from the hypercube,
In the following example pt_dim.Count()=3 and pt_m.Count()=2 and numOfColumns= 2.
I also noticed that the HyperCubeMode is DATA_MODE_PIVOT_STACK and I tried to change it but it didn't work.
This also happens in linechart with multiple dimensions.
The code:
IGenericObject iGenObj = (IGenericObject)iapp.GetGenericObject(objId);
Pivottable pt = (Pivottable)iGenObj;
mode = pt.Properties.HyperCubeDef.Mode;//mode=NxHypercubeMode.DATA_MODE_PIVOT_STACK
IEnumerable<HyperCubeDimensionDef> pt_dim = pt.Properties.HyperCubeDef.Dimensions;//pt_dim.Count()=3
IEnumerable<HyperCubeMeasureDef> pt_m = pt.Properties.HyperCubeDef.Measures;//pt_m .Count()=2
HyperCubePager hcp = pt.HyperCubePager;
int numOfColumns = hcp.NumberOfColumns;//2
int numOfRows = hcp.NumberOfRows;
IEnumerable<NxDataPage> pages = hcp.GetData(new[] { new NxPage { Top = 0, Height = numOfRows, Left = 0, Width = numOfColumns } });
IEnumerable<NxCellRows> rows = page.Matrix;
//The matrix contains only measures columns data.
...
Thanks in advanced,
Moran