def execute_view_ui_dygraph(self,
cube_name,
view_name,
private=False,
elem_properties=None,
member_properties=None,
value_precision=2,
top=None):
"""
Useful for grids or charting libraries that want an array of cell values per row.
Returns 3-dimensional cell structure for tabbed grids or multiple charts.
Rows and pages are dicts, addressable by their name. Proper order of rows can be obtained in headers[1]
Example 'cells' return format:
'cells': {
'10100': {
'Net Operating Income': [ 19832724.72429739,
20365654.788303416,
20729201.329183243,
20480205.20121749],
'Revenue': [ 28981046.50724231,
29512482.207418434,
29913730.038971487,
29563345.9542385]},
'10200': {
'Net Operating Income': [ 9853293.623709997,
10277650.763958748,
10466934.096533755,
10333095.839474997],
'Revenue': [ 13888143.710000003,
14300216.43,
14502421.63,
14321501.940000001]}
},
:param top:
:param cube_name: cube name
:param view_name: view name
:param private: True (private) or False (public)
:param elem_properties: List of properties to be queried from the elements. E.g. ['UniqueName','Attributes', ...]
:param member_properties: List of properties to be queried from the members. E.g. ['UniqueName','Attributes', ...]
:param value_precision: number decimals
:return:
"""
cellset_id = self.create_cellset_from_view(cube_name=cube_name,
view_name=view_name,
private=private)
data = self.extract_cellset_raw(
cellset_id=cellset_id,
cell_properties=["Value"],
elem_properties=elem_properties,
member_properties=list(set(member_properties or []) | {"Name"}),
top=top,
delete_cellset=True)
return Utils.build_ui_dygraph_arrays_from_cellset(
raw_cellset_as_dict=data, value_precision=value_precision)
def execute_mdx_ui_dygraph(self,
mdx,
elem_properties=None,
member_properties=None,
value_precision=2,
top=None):
""" Execute MDX get dygraph dictionary
Useful for grids or charting libraries that want an array of cell values per column
Returns 3-dimensional cell structure for tabbed grids or multiple charts
Example 'cells' return format:
'cells': {
'10100': [
['Q1-2004', 28981046.50724231, 19832724.72429739],
['Q2-2004', 29512482.207418434, 20365654.788303416],
['Q3-2004', 29913730.038971487, 20729201.329183243],
['Q4-2004', 29563345.9542385, 20480205.20121749]],
'10200': [
['Q1-2004', 13888143.710000003, 9853293.623709997],
['Q2-2004', 14300216.43, 10277650.763958748],
['Q3-2004', 14502421.63, 10466934.096533755],
['Q4-2004', 14321501.940000001, 10333095.839474997]]
},
:param top:
:param mdx: String, valid MDX Query
:param elem_properties: List of properties to be queried from the elements. E.g. ['UniqueName','Attributes', ...]
:param member_properties: List of properties to be queried from the members. E.g. ['UniqueName','Attributes', ...]
:param value_precision: Integer (optional) specifying number of decimal places to return
:return: dict : { titles: [], headers: [axis][], cells: { Page0: [ [column name, column values], [], ... ], ...} }
"""
cellset_id = self.create_cellset(mdx)
data = self.extract_cellset_raw(
cellset_id=cellset_id,
cell_properties=["Value"],
elem_properties=elem_properties,
member_properties=list(set(member_properties or []) | {"Name"}),
top=top,
delete_cellset=True)
return Utils.build_ui_dygraph_arrays_from_cellset(
raw_cellset_as_dict=data, value_precision=value_precision)
