Hi,

I have 10 tables each represent a product category. I have
created 10 cubes for all these products. However, I need
to create a cube that combine all the product categories.
Is it possible to do it?

Thanks

Yes you can if the 10 cubes have at least 1 shared dimension in common.
In that case you can create a virtual cube that is the union of the 10
original cubes.
I suggest you:
1) create a shared dimension "Product Category" that contains values from 1
to 10 (and description you need).
2) add a "Product Category" column in every cube with every row having the
same value (the value of the product
category of the cube)
3) add the shared dimension "Product Category" in every "real" cubes and
hide it.
4) create the virtual cube and in this cube show the shared dimension
"Product Category"
Now you can navigate through your ten Product Category as you like.

Francesco