Contents MDDB Report Viewer Methods Previous Next
 

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

Contents MDDB Report Viewer Methods Previous Next