/content/folder[@name='Samples']/folder[@name='Cubes']/package[@name='Sales and Marketing (cube)']/model[@name='2008-07-25T15:28:38.072Z']
[sales_and_marketing].[Time].[Time].[Year][sales_and_marketing].[Time].[Time].[Quarter][sales_and_marketing].[Products].[Products].[Product line][sales_and_marketing].[Measures].[Revenue]
[sales_and_marketing].[Measures].[Revenue][sales_and_marketing].[Measures].[Planned revenue][sales_and_marketing].[Time].[Time].[Year]
<script>
var paulScripts = {}, oCR = cognos.Report.getReport( "_THIS_" );
paulScripts.getControl = function (promptName) {
return oCR.prompt.getControlByName(promptName);
}
paulScripts.getElement = function(objectName){
var oCV = window['oCV'+'_THIS_'];
oCV.initializeLayoutElements()
return oCV.getLayoutElementFromLid(objectName+'_THIS_');
}
/*
* This will loop through every chart and replace multiple drill definitions with one.
*/
paulScripts.fixChartDrills = function(chartName){
var oCV = window['oCV'+'_THIS_']
, areas = paulScripts.getElement(chartName).parentNode.previousSibling.getElementsByClassName('chart_area')
, areasLen = areas.length
, areaDataItemName
, drills=[]
, dtargets=[]
;
for (var i=0;i<areasLen;++i){
if(!areas[i].getAttribute('dttargets')) continue;
areaDataItemName=oCV.getDataItemName(areas[i].getAttribute('ctx'));
drills = areas[i].getAttribute('dttargets');
dtargets =drills.split('>');
for (var j=0;j<dtargets.length;++j){
var regexp = /label...(.+?)."/g;
var match = regexp.exec(dtargets[j]);
if(match&&match[1] == areaDataItemName) areas[i].setAttribute('dttargets',dtargets[j]+'>');
}
}
}
</script>
No Data Available
<script>
paulScripts.fixChartDrills('Combination Chart1');
</script>
Report