Get Free Trial
Get Free Trial
All documentation
API reference
Objects
Methods
  1. All methods
  2. addCalculatedMeasure
  3. addCondition
  4. alert
  5. clear
  6. clearFilter
  7. clearXMLACache
  8. closeFieldsList
  9. collapseAllData
  10. collapseCell
  11. collapseData
  12. connectTo
  13. customizeAPIRequest
  14. customizeCell
  15. customizeChartElement
  16. customizeContextMenu
  17. dispose
  18. drillDownCell
  19. drillUpCell
  20. expandAllData
  21. expandCell
  22. expandData
  23. exportTo
  24. getAllConditions
  25. getAllHierarchies
  26. getAllHierarchiesAsync
  27. getAllMeasures
  28. getAllMeasuresAsync
  29. getCell
  30. getColumns
  31. getColumnsAsync
  32. getCondition
  33. getFilter
  34. getFlatSort
  35. getFormat
  36. getMeasures
  37. getMeasuresAsync
  38. getMembers
  39. getMembersAsync
  40. getOptions
  41. getReport
  42. getReportFilters
  43. getReportFiltersAsync
  44. getRows
  45. getRowsAsync
  46. getSelectedCell
  47. getSort
  48. getTableSizes
  49. getXMLACatalogs
  50. getXMLACatalogsAsync
  51. getXMLACubes
  52. getXMLACubesAsync
  53. getXMLADataSources
  54. getXMLADataSourcesAsync
  55. getXMLAProviderName
  56. getXMLAProviderNameAsync
  57. load
  58. off
  59. on
  60. open
  61. openCalculatedValueEditor
  62. openFieldsList
  63. openFilter
  64. print
  65. refresh
  66. removeAllCalculatedMeasures
  67. removeAllConditions
  68. removeCalculatedMeasure
  69. removeCondition
  70. removeSelection
  71. runQuery
  72. save
  73. scrollToColumn
  74. scrollToRow
  75. setFilter
  76. setFlatSort
  77. setFormat
  78. setOptions
  79. setReport
  80. setSort
  81. setTableSizes
  82. shareReport
  83. showCharts
  84. showGrid
  85. showGridAndCharts
  86. sortFieldsList
  87. sortingMethod
  88. sortValues
  89. updateData
Events
Custom data source API
MongoDB Connector API
Flexmonster Connector for amCharts
  • API Reference for older versions

    • getAllHierarchies

    getAllHierarchies(): Array

    [starting from version: 1.4]

    Returns a list of all available fields. Note that getAllHierarchies has an async equivalent - getAllHierarchiesAsync.

    Returns

    Array of ResultHierarchyObjects that describe available fields.

    If data load is in progress an empty array will be returned.

    Example

    pivot.getAllHierarchies();

    /* method returns an array of ResultHierarchyObjects
    [
      {caption: "Business Type", uniqueName: "Business Type", type: "string"},
      {caption: "Category", uniqueName: "Category", type: "string"},
      {caption: "Country", uniqueName: "Country", type: "string"}
    ]
    */

    Check out on JSFiddle.

    See also

    getAllHierarchiesAsync
    getAllMeasures
    getColumns
    getRows
    getReportFilters
    getMeasures