Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Combine data from two cubes (problem with navigational attributes)

Hi All,

I'm strugling with the following challenge:

I need to combine the objects from two cubes for a report, but they're navigational attributtes in one of them.

Example:

Cube 1 Orders

IO 0PM_ORDER

- IO ORDER__0EQUIPMENT (navigational attr)

- IO ORDER__0FUNCT_AREA (navigational attr)

TIME 0FISCPER

KYF 0AMOUNT

Cube 2 Counter

IO 0EQUIPMENT

IO 0FUNCT_AREA

TIME 0FISCPER

KYF 0COUNTER

I want to report on:

FISCPER

0AMOUNT

0COUNTER

0EQUIPMENT

0FUNCT_AREA

What's the best way to create this?

Thanks in advance!

I will reward usefull replies!

Former Member
Former Member replied

Build Multicube over the two cubes and in the identification link the navigational object and the saved object together. Then build your report over the multicube.

Thanks

Yashu Raj

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question