Join in MultiCube

22 Views

Hi Folks,

i have the following problem.

I have two basis cubes:

1. Cube:

PBWTC_DES

CHARACTERS:

OBJECTVERSION

SYSTEM

0TCTIFCUBE

DIMENSIONTABLE

KEYFIGURE:

Table Entries

Percentage

Time & Datapackegae as well.

2. Cube:

PBWTC_DO

CHARACTERS:

OBJECTVERSION

SYSTEM

0TCTIFCUBE

DATAOWNER

INFOAREA

KEYFIGURE:

Count

Time & Datapackegae as well.

With one cube (PBWTC_DO) get informations haw many cubes are assigned to one person.

With the second cube (PBWTC_DES) i see the cube compression.

In both cubes i have the cube name. I created a multicube with all character and keyfigures from the two basis cubes since i would like to combine the informations of both basis cubes in one report. When i run a report on the mulsti cube i get data for user and cube. and as a unasigned (#) character i only see the sum of the cube compression. But at the end i would like to have this in one row. Is this kind of compination possible? To have a kind of join on the character 0TCTIFCUBE or do i need another solution for this?

I apreciate any hint.

Best regards,

Maik.

PS: The identification is also done in the multicube.