You would likely want to create inline views that perform the filtering *before *performing t he cubes/rollup; in this way the cubes/rollups only operate on the pruned rows/columns.
2016-11-03 11:29 GMT-07:00 Andrés Ivaldi <iaiva...@gmail.com>: > Hello, I need to perform some aggregations and a kind of Cube/RollUp > calculation > > Doing some test looks like Cube and RollUp performs aggregation over all > posible columns combination, but I just need some specific columns > combination. > > What I'm trying to do is like a dataTable where te first N columns are may > rows and the second M values are my columns and the last columna are the > aggregated values, like Dimension / Measures > > I need all the values of the N and M columns and the ones that correspond > to the aggregation function. I'll never need the values that previous > column has no value, ie > > having N=2 so two columns as rows I'll need > R1 | R2 .... > ## | ## .... > ## | null .... > > but not > null | ## .... > > as roll up does, same approach to M columns > > > So the question is what could be the better way to perform this > calculation. > Using rollUp/Cube give me a lot of values that I dont need > Using groupBy give me less information ( I could do several groupBy but > that is not performant, I think ) > Is any other way to something like that? > > Thanks. > > > > > > -- > Ing. Ivaldi Andres >
