Skip to Content

Error Filterpanel with two Target Data Source

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

filterpanel.jpg (273.4 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Jan 08, 2015 at 07:03 AM

    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) ;
    });
    
    Add comment
    10|10000 characters needed characters exceeded

    • 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.