SeriesDefinition seriesDefinition = SeriesDefinitionImpl.create();	
Series series = createSeries("Bar Chart", "row[\"axisZ\"]");
series.setTranslucent(true);
series.getDataDefinition().add(QueryImpl.create("row[\"axisZ\"]"));

ActionHandle actionHandle = ModleUtil.deserializeAction((InputStream)null);
actionHandle.setLinkType(DesignChoiceConstants.ACTION_LINK_TYPE_HYPERLINK);
actionHandle.setURI("'http:\\www.yahoo.com&aa='+row[\"axisX\"]");

String sBaseUrl = ModuleUtil.serializeAction(ActionHandle);
URLValue uv = URLValueImpl.create(sBaseUrl,null,null,null,null);
seriesDefinition.getSeries().add(series);

	private static ScriptDataSetHandle createScriptDataSet(ElementFactory factory, Reportlet reportlet, String reportletDataSetName, String dataSourceName) throws SemanticException {
		ScriptDataSetHandle dataSet = factory.newScriptDataSet(reportletDataSetName);
		dataSet.setDataSource(dataSourceName);
		dataSet.setEventHandlerClass(SCRIPTED_EVENT_HANDLER);
		CachedMetaData cmd = StructureFactory.createCachedMetaData();
		CachedMetaDataHandle cachedMetaDataHandle = dataSet.setCachedMetaData(cmd);
		
		int position = 0;
		addDataSetColumn(dataSet, cachedMetaDataHandle, "axisX", "AxisX", "string", position++);
		if(StringUtils.isNotBlank(reportlet.getAxisY())) addDataSetColumn(dataSet, cachedMetaDataHandle, "axisY", "AxisY", "string", position++);
		addDataSetColumn(dataSet, cachedMetaDataHandle, "axisZ", "Count", "decimal", position++);
               
                //here,add the id for hyperlink using.eg:addDataSetColumn(dataSet, cachedMetaDataHandle, "drill_assetId", "drill_assetId", "string", position++);

                 
                 


		

		return dataSet;
	}

	private static void addDataSetColumn(ScriptDataSetHandle dataSet, CachedMetaDataHandle cachedMetaDataHandle, String columnName, String columnDisplayName, String columnType, int columnPosition) throws SemanticException {
		ColumnHint ch = StructureFactory.createColumnHint();
		ch.setProperty("columnName", columnName);
		ch.setProperty("displayName", StringUtils.capitalize(columnName));
		dataSet.getPropertyHandle(ScriptDataSetHandle.COLUMN_HINTS_PROP).addItem(ch);

		ResultSetColumn rs = StructureFactory.createResultSetColumn();
		rs.setColumnName(columnName);
		rs.setPosition(columnPosition);
		rs.setDataType(columnType);
		PropertyHandle propertyHandle = dataSet.getPropertyHandle(ScriptDataSetHandle.RESULT_SET_PROP);
//		logger.debug("rusult set properties handler: {}",  propertyHandle);
		propertyHandle.addItem(rs);
		
		rs = StructureFactory.createResultSetColumn();
		rs.setColumnName(columnName);
		rs.setPosition(columnPosition + 1);
		rs.setDataType(columnType);
		cachedMetaDataHandle.getResultSet().addItem(rs);
//		SimpleValueHandle svh = dataSet.getPropertyHandle(ScriptDataSetHandle.CACHED_METADATA_PROP);
//		logger.debug("CACHED_METADATA_PROP value: {}", svh.getValue());
//		CachedMetaDataHandle cmd = dataSet.getCachedMetaDataHandle();
//		PropertyHandle crs = (PropertyHandle) cmd.getProperty("resultSet");
//		logger.info("csr: {}", crs);
//		crs.addItem(rs);
	}