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

Popular posts from this blog

get url and add instance to a model with prefilled foreign key :django admin -

css - Make div keyboard-scrollable in jQuery Mobile? -

ruby on rails - Seeing duplicate requests handled with Unicorn -