2 Replies Latest reply on Aug 14, 2014 7:38 AM by Christian Berg

    dynamic row hiding in a column selector  table view report


      Hi All

      i am facing a critical requirement in my Project , We have a report where we are using 3  groups of column selector. when we select values in column selector report get displayed in a view selector where we have different views like table view , chart Graph. Now when user is selecting some values in column selectors then in reports few row are returning 0  values in all the column. so user does not display those row and having 0's in all the columns of the row does not make sense for business. Please help how can i achieve this . as per my understanding we cant restrict the data at RPD level as the values in column selector which is returning  0's for some row can show the value for other sets of row.

      we are using OBIEE 10g .