ig.OlapTableViewResultCell

ig.OlapTableViewResultCell_image
Provides information about the content of the data cell and how it relates to $.ig.Cell object.

Code Sample

<!doctype html>
<html>
<head>
    <!-- jQuery Core -->
    <script src="js/jquery.js" type="text/javascript"></script>
    <!-- jQuery UI -->
    <script src="js/jquery-ui.js" type="text/javascript"></script>
    <!-- Infragistics Combined Scripts -->
    <script src="js/infragistics.core.js" type="text/javascript"></script>
    <script src="js/infragistics.lob.js" type="text/javascript"></script>
    <script type="text/javascript">
        $.support.cors = true;                
        $(function () {
            var dataSource = new $.ig.OlapXmlaDataSource({
                serverUrl: "http://sampledata.infragistics.com/olap/msmdpump.dll",
                catalog: "Adventure Works DW Standard Edition",
                cube: "Adventure Works",
                rows: "[Date].[Calendar]",
                measures: "[Measures].[Customer Count], [Measures].[Internet Order Count]"
            });
			
            dataSource.initialize().done(function(metadataTree) {
                // the result of the pre-loaded rows, columns, filters and measures is evaluated as part of initialization 
                var result = dataSource.result();
            
                var viewSettings = {
                    isParentInFrontForColumns: true,
                    isParentInFrontForRows: true,
                    compactRowHeaders: true,
                    compactColumnHeaders: false
                };
            
                var hasColumns = dataSource.columnAxis().length > 0;
                var hasRows = dataSource.rowAxis().length > 0;

                // create and initialize the table view
                var tableView = new $.ig.OlapTableView(result, hasColumns, hasRows, viewSettings);
                tableView.initialize();
            
                // obtain layout information about result's row and column headers and its data cells
                var columnHeaders = this._tableView.columnHeaders();
                var rowHeaders = this._tableView.rowHeaders();
                var resultCells = tableView.resultCells();
            });
        });            
    </script>
</head>
<body>
</body>
</html>    
    

Related Topics

Dependencies

jquery-1.9.1.js
infragistics.util.js
The current widget has no options.
The current widget has no events.
  • cellOrdinal

    .cellOrdinal( );
    Return Type:
    number
    Return Type Description:
    The cell ordinal.

    Returns the ordinal of this cell used to determine its position into the data cells' grid.

  • formattedValue

    .formattedValue( );
    Return Type:
    string
    Return Type Description:
    The formmated value to be displayed by the data cell.

    Returns the formmated value to be displayed by the data cell.

  • resultCellIndex

    .resultCellIndex( );
    Return Type:
    number
    Return Type Description:
    The index of $.ig.Cell object this result cell is related to.

    Returns the index of $.ig.Cell object in $.ig.OlapResult object.

  • value

    .value( );
    Return Type:
    object
    Return Type Description:
    The value of the data cell.

    Returns the value provided by $.ig.Cell object.

Copyright © 1996 - 2024 Infragistics, Inc. All rights reserved.