Distinct Count in dimensional report, help me!!

[lorenmario]

Please, I need help!

I created a cube that contains an indicator called Visit, it returns the number of customer visits, need it to be distinct count, but the transformer does not have distinct count rollup.

Publish cube in portal and created the report, I tried to create a calculated item as follows:

count (distinct ([Visit]))

But it does not work!!

I tried to change the aggregation of the field, but this function is not available ...

Can anyone help me?!

Thank you!

[blom0344]

A link:

http://www-01.ibm.com/support/docview.wss?uid=swg21348648

[lorenmario]

Hi Friend, thanks for the reply.

Has no other solution??

I'm desperate ...