Error Filterpanel with two Target Data Source

[former_member201696]

Hi all,

I use Design Studio 1.4. Server BOE 4.1 SP4 Patch 4.

1. I have create a report with data source 1 (DS_1) and data source 2 (DS_2), both data source hase the same query's.

2. I have create a cross tab withe data source DS_1.

3. I have create a filter panel with the setting data source DS_2 and target data source DS_1 and DS_2.

4. If I execute the report i can set a new filter in the filterpanel and after i push the button submit the cross tab are filtered.

5. But if I change the the navigation of the dimensions in the filterpanel and after i push the button submit in the cross tab happen nothing.

Can somebody help me and try to create the same report.

I have try a lote of solutions, but nothing helps.

Best Regards

Gabriel Motor

[Former Member · Accepted solution]

Hi,

Add Below Code in On Apply of Filter Panel .

var Rowaxis = DS_1.getDimensions(Axis.ROWS) ;
Rowaxis.forEach(function(dimension_Rows, index) {
  DS_2.moveDimensionToRows(dimension_Rows) ;
});


var Colaxis = DS_1.getDimensions(Axis.COLUMNS) ;
Colaxis.forEach(function(dimension_Cols, index) {
  DS_2.moveDimensionToRows(dimension_Cols) ;
});

[former_member201696 · Accepted solution]

Hi Nikhil

Thanks for the input. it works but i have extended the script with cleanup the old dimension, because if you would like to remove a dimension your script it will not work.

var DeletRowaxis = DS_2.getDimensions(Axis.ROWS) ; 
DeletRowaxis.forEach(function(deletdimension_Rows, index) { 
DS_2.removeDimension(deletdimension_Rows) ; 
}); 
var DeletColaxis = DS_2.getDimensions(Axis.COLUMNS) ; 
DeletColaxis.forEach(function(deletdimension_Cols, index) { 
DS_2.removeDimension(deletdimension_Cols) ; 
}); 

var Rowaxis = DS_1.getDimensions(Axis.ROWS) ; 
Rowaxis.forEach(function(dimension_Rows, index) { 
DS_2.moveDimensionToRows(dimension_Rows) ; 
}); 
var Colaxis = DS_1.getDimensions(Axis.COLUMNS) ; 
Colaxis.forEach(function(dimension_Cols, index) { 
DS_2.moveDimensionToColumns(dimension_Cols) ; 
}); 

But I'm not so happy about the solution. For me hase the filterpanel a bug.