Join in MultiCube

[Former Member]

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.

[Former Member]

Use Constant selection option.

The characteristics you want to appear regardless of unassigned, right click and choose option "constant selection".

This should solve your problem.

Farhan

[Former Member]

For details on constant selection, see this blog:

/people/prakash.darji/blog/2006/09/19/the-hidden-secret-of-constant-selection