Jedox OLAP documentation

home > API > [/dimension/cubes] >
request url https://[SERVER]:[PORT]/dimension/cubes[?PARAMETER1=value[&...]]
short description Returns the list of cubes using a dimension
long description
parameters
name type description
database identifier Identifier of the database
name_database string Name of the database. Used only if database parameter is omitted.
dimension identifier Identifier of the dimension
name_dimension string Name of the dimension. Used only if dimension parameter is omitted.
show_normal identifier Show cubes of type normal (0=do not show normal cubes, 1=show (default))
show_system identifier Show cubes of type system (0=do not show system cubes (default), 1=show)
show_attribute identifier Show cubes of type attribute (0=do not show attribute cubes (default), 1=show)
show_info identifier Show cubes of type user info (0=do not show user info cubes (default), 1=show)
show_gputype identifier Show cubes of type gpu type (0=do not show gpu type cubes , 1=show (default))
sid string Session identifier for a server connection. Use the /server/login request to get a valid session identifier.
result
# name type description
0 cube identifier Identifier of the cube
1 name_cube string Name of the cube
2 number_dimensions integer Number of dimensions
3 dimensions identifier Comma separated list of dimension identifiers
4 number_cells double Total number of cells
5 number_filled_cells integer Number of filled numeric base cells plus number of filled string cells
6 status integer Status of cube (0=unloaded, 1=loaded and 2=changed)
7 type integer Type of cube (0=normal, 1=system, 2=attribute, 3=user info, 4=gpu type)
8 cube_token integer The cube token of the cube
examples
description
List the cubes of dimension "2" of database "1"
further information