olap - MDX (calculations) - count all clients accounts -
i count clients accounts in cube. have created new calculation , wrote query in mdx langugage like:
count( [client].[idclient] )
but when know how many accounts have, '1' value instead e.g. '6000'. first time mdx , olap cubes. supposed correct value?
try this:
count( existing [client].[idclient].[idclient].members )
if aren't happy performance of delete calculated measure , replace measure group built on client table. build count measure.
Comments
Post a Comment