Join in cubes

Hi all,

Is it possible that i make join between two or more cubes.

I mean to say suppose i have two cubes cube A and cube B

cube A contain

material number. material-description -

---

material-type -- qty

1--

---

AB

---

134 --

---

32

2--

---

xy

---

134 --

---

40

3--

---

z

---

134 --

---

50

material number. material-description --- material-type --- price

1--

---

AB

---

134 --

---

10

2--

---

XY

---

134 --

---

20

Result which i want in my query

material number. material-description -- material-type -- qty -- price

1--

---

AB

---

134

---

32 --

---

10

2--

---

XY

---

134

---

40 --

---

20

Is it possible in BW if yes then please help me out.

Thanks and regards

Ankit modi