I think I have finally found the solution by myself. What I was missing is to uncheck the box "Only users with SysAdmin privileges can execute CmdExec and Active Scripting...

Thanks a lot.

delpiero

Thanks Jonathan and Tiago, I have got the solution from your advice.

Just one more issue, I granted execute privilege of my T-SQL stored proc to the APP_USER database user...

I can use DTS Export/Import wizard to choose a SQL Server table as source, and an OLAP Analysis Services cube as destination, but it does not allow me to export...

Do u mean refresh the cube through DTS and then call the DTS package through xp_cmdshell? But can you tell me how to refresh the cube through DTS?

Thanks,

delpiero

Do u mean u r unable to browse the data from the default "FoodMart" cube?

Did u install Service Pack 3a of Analysis Services?

delpiero

Just one minor issue is that when I used the asterisk it prompted me error, but it worked fine when I used the "crossjoin" function.

delpiero

Hi Steve,

        The cross join is exactly what I need and it solved my problem. It saves me hours of work. Many many thanks!

Best regards,

delpiero

Thanks JG,

       For Method 1, is it I can't use it if my original fact table does not have the members 100,200? They are just treated as rollup members and they...

Were you able to create the linked server using Enterprise Manager?

And did you have the latest service pack applied for your analysis server?

The linked server method works fine. Thanks a lot!

Thanks,

      Besides using Excel, how can we utilize the Pivot Table Service through a front-end interface? Is it possible to access the cube or execute an MDX statement using ADO?

delpiero

Steve,

         Thanks for your reply. I think I have successfully typed in the case statement in the property field. I guess I made some careless mistakes before. So, now I...

I am using MSSQL and I know that such syntax is valid in Query Analyzer, but it just does not allow me to insert this code in the member properties...

Thanks steve,

         I used your method but afterI typed the <code> </code> part in the 2 properties, it would prompt me "the column property is invalid" and revert back to...