Good day everyone,
I am trying to do something I'd consider simple and straight-forward and, yet, I'm failing over and over again. It seems to me I'm missing some basic understanding around Hyper Cubes and how Qlik manages and serves this kind of object.
The ask is simple: to print all the contents in a Table defined by a HyperCube. Below is my .NET/C# code with comments where the problem's been raised:
public int PrintTableFromHypercube(string[] dims, int max_rows) {
try {
// Defines the Hypercube objects
QE.HyperCubeDef hyper_cube = new QE.HyperCubeDef();
List<HyperCubeDimensionDef> dim_defs = new List<HyperCubeDimensionDef>();
List<HyperCubeMeasureDef> measure_defs = new List<HyperCubeMeasureDef>();
dim_defs.Add(new HyperCubeDimensionDef { Def = new HyperCubeDimensionqDef { FieldDefs = dims } });
measure_defs.Add(new HyperCubeMeasureDef { Def = new HyperCubeMeasureqDef { Def = "1" } });
hyper_cube.Dimensions = dim_defs;
hyper_cube.Measures = measure_defs;
QE.GenericObjectProperties generic_prop = new QE.GenericObjectProperties();
generic_prop.Info = new QE.NxInfo();
generic_prop.Info.Type = "hypercube";
generic_prop.Set<QE.HyperCubeDef>("qHyperCubeDef", hyper_cube);
// Creates the Hypercube on the actual Application
QE.GenericObject obj = QlikApp.CreateGenericSessionObject(generic_prop);
var pager = new QE.NxPage { Top = 0, Left = 0, Width = dims.Length, Height = max_rows };
var qlik_data = obj.GetHyperCubeData("/qHyperCubeDef", new[] { pager });
var hyper_cube_pager = obj.GetHyperCubePager("/qHyperCubeDef");
var current_page = hyper_cube_pager.GetFirstPage();
var data_page = current_page.FirstOrDefault();
// Keeps reading data while the page is not empty.
while (data_page.Matrix.Count() > 0) {
// Reads each row from the current page of data.
foreach (var row in data_page.Matrix) {
/****************************************************
Here's where the problem is: No matter how many fields or measures
I add, my "row" object will always return a single NxCell. So, it seems
like I cannot traverse those values to print on the screen.
*****************************************************/
Debug.WriteLine($"Current row has '{row.Count}' elements");
// Reads each field in the current row
for (int i=0; i< dims.Length; i++) {
Debug.Write($"Field '{dims[i]}': '{row.ElementAt(i).Text}'\t");
}
Debug.Write("\n");
}
// Jumps to the next page of data from the pager
data_page = hyper_cube_pager.GetNextPage().ToArray()[0];
}
return 0;
} catch {
return ~1;
}
}Thanks in advance for your help
