Announcement

**curiousgally** · 27 Apr 2011, 00:16

Is it mandatory to do cubeGrid.setdata() prior to adding it to another component.
Because the following code simply renders cube grid undrawn.
How do i debug the reasons why a component is undrawn ??

Code:

VLayout rLayout = new VLayout();
CubeGrid cGrid = createCubeGrid();
 rLayout.addMember(cGrid);

Code:

public CubeGrid createCubeGrid() {

         final CubeGrid cubeGrid = new CubeGrid();
            //in order to enable charting, the Drawing module must be present
            if(SC.hasDrawing()) {
                cubeGrid.setEnableCharting(true);
            }
            cubeGrid.setDataSource(DataSource.get("adb"));
            cubeGrid.setFetchOperation("cubeGrid");
            cubeGrid.setWidth100();
            cubeGrid.setHeight100();
            cubeGrid.setHideEmptyFacetValues(true);
            cubeGrid.setShowCellContextMenus(true);
             DataSource dS = DataSource.get("adb");
                DSRequest dSR = new DSRequest();
                dSR.setEndRow(12);
                dSR.setOperationId("cubeGrid");
                dS.fetchData(new Criteria(), new DSCallback() {
                    public void execute(DSResponse response, Object o, DSRequest request) {
                        cubeGrid.setData(response.getData());
                    }
                }, dSR);

            final NumberFormat numberFormat = NumberFormat.getFormat("0,000");

            cubeGrid.setCellFormatter(new CellFormatter() {
                public String format(Object value, ListGridRecord record, int rowNum, int colNum) {
                    if (value == null) return null;
                    try {
                        return numberFormat.format(((Number) value).longValue());
                    } catch (Exception e) {
                        return value.toString();
                    }
                }
            });
            cubeGrid.fetchData();

            cubeGrid.setRowFacets("ORIG", "DEST");
            cubeGrid.setColumnFacets("dates", "bookings");

            return cubeGrid;
    }

But when I manually set data using cubeGrid.setData(...) it is drawn.

Can somebody tell me how a cube Grid is supposed to be initiated when I need to create facets on the fly from the database result.

**Isomorphic** · 27 Apr 2011, 04:28

First, an obvious flaw: it doesn't make sense to call both cubeGrid.setData() and cubeGrid.fetchData().

Beyond that, creating a cube from data fetched from the server is exactly the same as creating it directly. Just put all of your code for creating the cube into the DataSource.fetchData() callback. Before then, the cube has nothing to show, so there's no point in drawing it or adding it to any parent.

Finally, as we told you off-forum:

Please be sure to:
1. look in the Developer Console for errors or warnings
2. if you need further help, update the thread with what you see in the Developer Console as well as the data being provided to the cube
3. provide the exact version you're using

**curiousgally** · 27 Apr 2011, 04:58

Thanks for the response.

In the advanced Cube Grid sample facet values have been harcoded with values like : Regions (North,South,West,East).

I'm trying to create a cube grid and my table schema is :

Origin Airport, Origin City, Origin Country, Origin Area, Destination , Destination City, Destination Country, Destination Area, Bookings, Month ,Year.

I need to create a facet like Origin which is a tree. with the following relations:

Origin Area
|
Origin Country
|
Origin City
|
Origin Airport

The number of cities and airports in the world is huge to hardcode like in the sample. Also all data need not be fetched. Only based on user selected criteria a cube grid needs to be generated. Hence creation of Facet Values of Facets need to be dynamic.

Is this possible.

I'm using the nightly build version.

Thanks.

**Isomorphic** · 27 Apr 2011, 05:10

If the number of airports is only a few thousand and you don't have a need to support IE6 (IE7+ should be fine) you could load the whole thing.

Otherwise we would recommend using a load-on-demand TreeGrid to select portions of the Area/Country/City/Airport hierarchy, then have the user press a button to cause a cube to be built showing that subset of the hierarchy.

**curiousgally** · 27 Apr 2011, 05:18

There are around 10,000 airports in the world. So tree approach makes more sense.

But with the tree approach how to set the Facet Values??

**curiousgally** · 27 Apr 2011, 05:21

So wee need to query seperately for setting Facets and then construct the cube grid. Data of the cube grid will be taken care by the datasource associated with cube grid. Did i understand it right ?

**Isomorphic** · 27 Apr 2011, 05:27

Right, that's the general technique for load on demand with dynamic facets.

**curiousgally** · 27 Apr 2011, 06:22

What if the data in the table is not grouped at the level at which facets are created. Will it be automatically grouped when cell values are fetched.

**Isomorphic** · 27 Apr 2011, 06:24

Don't really follow the question, but, tree facets fetch like other facets: in the Criteria, they provide a list of facetValues for which data is required. This may or may not map directly to your SQL table, if not, you can use a DMI to change the criteria in whatever way is required.

**curiousgally** · 27 Apr 2011, 06:28

I have sample rows like this:

BOM, DEL, 100 //(origin,destination,booking Count)
BOM, CCU, 200
DEL, CCU, 120
BOM, DEL, 110
BOM, CCU, 100

From the previous discussion, if I'm constructing a cub grid with facet Values as BOM,DEL for origin facet and DEL,CCU for destination facet. The cubeGrid needs to populate data after grouping it accordingly.

But your DMI approach seems to answer my question.

**curiousgally** · 27 Apr 2011, 07:44

Some doubts,

1) the "sum" FacetValue in the advanced Cube Grid sample is it directly calculated and put in the database on Cube Grid is calculating it on the fly based on data. I got this doubt because i see the following query:

Code:

SELECT DEST, DOMAIRL, ORG_CNTRY_CD, ORIG, DEST_CTY_CD, fare, SECURITY_ID, revenue, PAX_COUNT, DATES, DEST_CNTRY_CD, ORG_CTY_CD FROM adb WHERE (ORIG='CCU' AND ((DEST='sum') OR (DEST='IN')))

2) I have created facet values as discussed in the previous posts, but in the facet values,parent is a different column entry in the table ,

say.. in case of origin facet;
US (country-USA)
|
NYC(airport-new york)

US is mapped to column Origin Country in the table
where as NYC is mapped to Origin Airport in the table.

If you observe the sql that cubegrid generates it searches for "IN" in ORIG column only.

So how to differentiate this.

Basically i wanted to know how this whole cubeGRid query which it runs against can be customized according to facets.

3) though I set cubeGrid.setFetchOperationId(..) it seems to always query with default fetch ignoring the operitionBinding given.

Hope i'm clear !

**Isomorphic** · 27 Apr 2011, 07:58

1) in the sample, it's pre-calculated in the dataset. You can either pre-calculate it as well or calculate it on the fly on the server. It can't be calculated client-side since load on demand means only part of the data is available.

2) you can modify dsRequest.criteria server-side to split the list of ORIG values between your two columns.

3) oops, you're correct. This has now been fixed and the fix will appear in the next nightly build. In the meantime you can just declare an operationBinding that has no operationId and the settings on that operationBinding (DMI et al) will be used by the cube.

**curiousgally** · 27 Apr 2011, 08:32

What handler should I set to configure the dsRequest as you mentioned.

**Isomorphic** · 27 Apr 2011, 08:35

Take a look at the sections in the QuickStart Guide on DMI.

Announcement

Cube Grid doesn't show up

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment