_GET_GRAPH_VALUES_ Method

Gets the numeric values for the 3-D clickable graph

Syntax

CALL SEND(OBJID,'_GET_GRAPH_VALUES_');

Details

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 drill-down subsets
calls _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 of 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.

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]