_GET_GRAPH_VALUES_ Method
Gets the numeric values for the 3D clickable graph.
The values are stored in the GRPHVALS_ instance variable;
thus the graph can be displayed with or without the report.
This method:
-
calls _BUILD_APPLICATION_LIST_ to build the application list
-
calls _SET_DRILL_LEVELS_ to set the drilldown subsets
-
calles _SET_APPLICATION_ of the data model to get the initial data table
-
calls _SET_ACTIVE_VALUE_ and _EXPAND_VALUE_ of the data model for each
fo the expanded variables (if necessary)
-
calls _GET_CLASS_COMBINATIONS_ of the data model to get the row class values
-
calls _GET_CLASS_COMBINATIONS_ of the data model to get the column class values
-
calls _GET_VALUES_ of the data model for each crossing from the row and column lists
-
calls _GET_CLASS_FORMAT_ for the analysis variable to get its format
-
adds the class values, the numerical data, and the format to the grphvals_ list
Syntax
CALL SEND(OBJID,'_GET_GRAPH_VALUES_');
Example
The GRPHVALS_ instance variable contains the following:
( ( COUNTRY='CANADA'
_ANLSYS_='Actual Sales'
_STATS_='Sum'
PRODTYPE='FURNITURE'
'97864'
'DOLLAR12.'
)[1073]
( COUNTRY='CANADA'
_ANLSYS_='Actual Sales'
_STATS_='Sum'
PRODTYPE='OFFICE'
'149126'
'DOLLAR12.'
)[227]
( COUNTRY='CANADA'
_ANLSYS_='Actual Sales'
_STATS_='Sum'
PRODTYPE='TOTAL'
'246990'
'DOLLAR12.'
)[1411]
( COUNTRY='GERMANY'
_ANLSYS_='Actual Sales'
_STATS_='Sum'
PRODTYPE='FURNITURE'
'101194'
'DOLLAR12.'
)[1631]
( COUNTRY='GERMANY'
_ANLSYS_='Actual Sales'
_STATS_='Sum'
PRODTYPE='OFFICE'
'144804'
'DOLLAR12.'
)[1711]
( COUNTRY='GERMANY'
_ANLSYS_='Actual Sales'
_STATS_='Sum'
PRODTYPE='TOTAL'
'245998'
'DOLLAR12.'
)[1715]
( COUNTRY='U.S.A.'
_ANLSYS_='Actual Sales'
_STATS_='Sum'
PRODTYPE='FURNITURE'
'91567'
'DOLLAR12.'
)[1719]
( COUNTRY='U.S.A.'
_ANLSYS_='Actual Sales'
_STATS_='Sum'
PRODTYPE='OFFICE'
'145782'
'DOLLAR12.'
)[1723]
( COUNTRY='U.S.A.'
_ANLSYS_='Actual Sales'
_STATS_='Sum'
PRODTYPE='TOTAL'
'237349'
'DOLLAR12.'
)[1727]
( COUNTRY='TOTAL'
_ANLSYS_='Actual Sales'
_STATS_='Sum'
PRODTYPE='FURNITURE'
'290625'
'DOLLAR12.'
)[1731]
( COUNTRY='TOTAL'
_ANLSYS_='Actual Sales'
_STATS_='Sum'
PRODTYPE='OFFICE'
'439712'
'DOLLAR12.'
)[1735]
( COUNTRY='TOTAL'
_ANLSYS_='Actual Sales'
_STATS_='Sum'
PRODTYPE='TOTAL'
'730337'
'DOLLAR12.'
)[1739]
)[1399]
|