• Hi Ron,

    you can use the approach shown in this article to create a report which gets its content from more than one cubes:

    For example you have one mdx which retrieves the number of invoices per customer. You can write the results into a temp-table with the technique shown in the article.

    Then you have another mdx from another cube (which then is another linked server) which gets the number of visits on your homepage per customer. Write this into another temp-table.

    Then you can (inner/outer) join these tables as you like (now we are in normal SQL environment again, where we can do whatever we like with the data).

    If the cubes are in the same database, have a look at the lookupcube-mdx function (s. http://msdn.microsoft.com/en-us/library/ms144720.aspx). This also could solve your problem.

    Hope that helped.

    Martin