Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Extending the Data Warehouse Tutorial NumbersTableDescriptor

Hi im working through the tutorial "Extending the Data Warehouse" and having some problems with the chapter "Designing the Tables ".

I have implemented the code and i get the error that the statement "SELECT" doesnt exist on continent.setAggregationKind(AggregationKind.SELECT);
and
number.setAggregationKind(AggregationKind.SELECT);

'AggregationKind.SELECT cannot be resolved'


import com.ibm.team.datawarehouse.common.AggregationKind;

import com.ibm.team.datawarehouse.common.FieldFlags;
import com.ibm.team.datawarehouse.common.FieldKind;
import com.ibm.team.datawarehouse.common.IFieldDescriptor;
import com.ibm.team.datawarehouse.service.AbstractTableDescriptorFactory;
import com.ibm.team.datawarehouse.service.ISnapshotService;
import com.ibm.team.datawarehouse.service.common.ICommonSnapshotService;
import com.ibm.team.repository.common.TeamRepositoryException;


public class NumbersTableDescriptorFactory extends AbstractTableDescriptorFactory{

@Override
/*protected void createTableDescriptors() throws TeamRepositoryException {
// TODO Auto-generated method stub

}*/

protected void createTableDescriptors() throws TeamRepositoryException {
createNumbersStorageFact();
}

private void createNumbersStorageFact() {
IFieldDescriptor id = createFieldDescriptor(
ISnapshotService.FACT_ID_COLUMN, FieldKind.LONG,
FieldFlags.DEFAULT);
IFieldDescriptor timeId = createFieldDescriptor(
ISnapshotService.TIME_ID_COLUMN, FieldKind.LONG,
FieldFlags.QUERYABLE);
IFieldDescriptor continent = createFieldDescriptor(
INumbersSnapshotService.CONTINENT_COLUMN,
FieldKind.STRING, FieldFlags.QUERYABLE | FieldFlags.PARAMETER);
IFieldDescriptor number = createFieldDescriptor(
INumbersSnapshotService.NUMBER_COLUMN,
FieldKind.INTEGER, FieldFlags.DEFAULT);
timeId.setReference(getTableDescriptor(
ICommonSnapshotService.SNAPSHOT_NAME,
ICommonSnapshotService.TIME_DIMENSION));
continent.setAggregationKind(AggregationKind.SELECT);
[color=red]number.setAggregationKind(AggregationKind.SELECT);[/color]
createTableDescriptor(
INumbersSnapshotService.NUMBERS_FACT_TABLE,
new IFieldDescriptor[] { id, timeId, continent, number },
id);
}



}

0 votes



4 answers

Permanent link
Example is out of date. An update to the example will be forthcoming.

0 votes


Permanent link
Updated the Wiki with up to date example.

0 votes


Permanent link
i worked through the tutorial and now i'm wondering how i can check if the jazzserver and rtc is working with the plugin.
If i look into the WebUI on Reports & Administer Data Warehouse i cannot find the case "NUMBERS_SNAPSHOT" on the combo box, but i have named it on the plugin.xml

I'm using the JazzServer-06-RTC10-Maximal.launch. to launch my plugin, but i still cant find the service.

0 votes


Permanent link
okay, i guess i've got it!

0 votes

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 10,938

Question asked: Sep 30 '08, 10:18 a.m.

Question was seen: 6,646 times

Last updated: Sep 30 '08, 10:18 a.m.

Confirmation Cancel Confirm