• Hi Vincent,

    I liked reading through your article, and then decided to follow you step by step. I was able to grab and restore the backup file, etc., and to run the SQL statements to create the Sales database. So far, so good. I got the Product Dimension set up, by using the dropdowns not by dragging it. But I have another problem, which I suspect concerns SSAS more than your project. But having nowhere else to turn, I'm turning to you.

    Unlike in your image, on my monitor in the large pane (Details) it says, "The query could not be processed. The data provider didn't supply any further error information."

    The moment I try to move anything to where you suggested, I immediately get the error message: "Error H_Result E_Fail has been returned from a call to a COM component."

    Any suggestions?

    Thanks in advance,

    Arthur

    P.S.

    A good read, and I'm eager to go through all the steps and make it work with my own stuff.

    Arthur Fuller
    cell: 647-710-1314

    Only two businesses refer to their clients as users: drug-dealing and software development.
    -- Arthur Fuller