Hi all,
I just want to know how the aggregation of measures works using BICS. When I read certain articles, they were mentioning about the Microcube(characters used in Query Panel) , the aggregation happens. If I am using vertical table and when I write any functions to any of the column contiaining a Dimension, then all the measures values becomes #unavailable. Hence, I created Variable of Dimension type having the measure and used the variable dimension for displaying measure.
Eg. V_Amt(Dimension)= amount.
suppose my original vertical table having 7 columns: 5 columns( Dimension)a nd 2 (measures), then my newly designed would be 7 columns(Dimensions).
But some occasion the measure value does NOT get displayed in single row(aggregated), instead displays as separate rows or sometimes the value become # unavailable.? I fixed the above issue by using for each statement
Why is this happens?Does measures doesnt know how to aggregate when we use a varaible dimension (instead of Measure) ?
But still I am confused is the aggregation happens on microcube or dimension used in vertical table.
Thanks