I have a cube named "Global Analysis".
It has a measures named "CustomerID" (==>> Integer)
I want this measures aggregate function is "Distinct Count".
It is ok when i process and i browse the result using olap. When I wany to use Excel as a pivot table, it's still ok (getdata, connect to database, etc..). Until the part when i want to set the layout/finish. It's error. The error said
"Excel cannot find OLAP cube Global Analysis. Either the olap databse has been changed or you dont have a permission to connect to the cube"
But when I changed "Distinct Count" to "Count" there is no problem at all.
The excel client and the server is in one machine, so i think there is no problem about the permission. I use "localhost".
Can anyone tell me how to solve this? Thank you very much.
It has a measures named "CustomerID" (==>> Integer)
I want this measures aggregate function is "Distinct Count".
It is ok when i process and i browse the result using olap. When I wany to use Excel as a pivot table, it's still ok (getdata, connect to database, etc..). Until the part when i want to set the layout/finish. It's error. The error said
"Excel cannot find OLAP cube Global Analysis. Either the olap databse has been changed or you dont have a permission to connect to the cube"
But when I changed "Distinct Count" to "Count" there is no problem at all.
The excel client and the server is in one machine, so i think there is no problem about the permission. I use "localhost".
Can anyone tell me how to solve this? Thank you very much.