Skip to Content
0
Former Member
Nov 06, 2012 at 04:27 PM

Aggregation using BICS

38 Views

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