Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Analysis Services (2000)
 Importing pivot table with distinct count

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-07-17 : 08:25:37
James Gan writes "I have this problem when using MDX function distinct count,
especially when i am counting customer name over 2 dimensions that are intersecting. eg. one customer that bought 2 different product yet have the same characteristic.
the OLAP give me a correct answer that i wanted. but when i importing it into Ms Excel using the inser pivot table function, an error message appears
"Excel.exe has generated errors and will be closed by Windows. You will need to restart the program"
i think the error occurs in Ms Excel, but anyone there have ever encounter such problems?
p/s: I am looking forward for an urgent feedback, please send it to my email: james_ghj@yahoo.com

rgrds,
James Gan HJ"
   

- Advertisement -