GetDataExport problem

    This site uses cookies. By continuing to browse this site, you are agreeing to our Cookie Policy.

    • GetDataExport problem

      Hello all,

      I'm testing the SDK function GetDataExport (.NET SDK version 3.1.0.336). This function sometimes returns 0.0 when the return value should be > 0.0. I use this function as follows:

      Source Code

      1. string[] paloDimensions = jpc.CubeListDimensions("MyDB", "MyCube");
      2. Array[] coordinateArray = new Array[paloDimensions.Count];
      3. string[] paloCoordinates1 = new string[] { "A", "B" };
      4. coordinateArray[1] = paloCoordinates1;
      5. string[] paloCoordinates2 = new string[] { "C", "D" };
      6. coordinateArray[2] = paloCoordinates2;
      7. GetDataExportOptions options = new GetDataExportOptions();
      8. options.IngoreEmptyCells = false;
      9. options.BaseElementsOnly = false;
      10. options.Filter = new ValueFilter();
      11. options.NumDatasets = 1; // Die Anzahl der Datasets ergibt sich im Folgenden aus den ermittelten Koordinaten
      12. foreach (string[] coordinateList in coordinateArray) {
      13. uint factor = (uint) coordinateList.Length;
      14. options.NumDatasets *= factor;
      15. }
      16. options.LastCoordinates = new string[0];
      17. double progressDummy = 0;
      18. Dataset[] paloResultSet = jpc.GetDataExport("MyDB", "MyCube", coordinateArray, options, true, ref progressDummy);
      19. foreach (Dataset paloResult in paloResultSet) {
      20. double cellValue = paloResult.Value.Value.DblValue;
      21. // cellValue is 0.0, but should be > 0.0
      22. }
      Display All


      Are the options set correctly? What could be the problem here?

      Could the function GetDataMulti be an alternative? This function returns CellValue[]. How could the coordinates be derived from this return value (e. g. the coordinates of the first cell).

      Thank you very much in advance.