MDDB Report Viewer 9.2

_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 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.

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]

Top of Page