Skip to Content
0
Former Member
Dec 05, 2006 at 09:01 AM

Multi Provider

25 Views

Hi Experts ,

I created 2 cubes ,

<b>Cube 1 :</b>

Char : Empno , Empname ,

KeyFig : Empsal .

<b>Cube 2 :</b>

Char : Empno1 , Designation

KeyFig : Empage .

Cube1 Eno = Cube2 Eno1 ( Same Employee No )

I Created multicube forming

Char : Eno ,Eno1 , Ename ,Edesg

KeyFig : Empsal ,Empage

In Char tab , Identification part , The 4 char are ticked .

In Keyfig ,Selection part , Age and salary are ticked .

<b>But Multicube Output shows like this</b>

First 2 rows = Cube 1 Data

Last 2 rows = Cube 2 Data

Eno ENo1 Desg Name Age Sal

1 X 1000

2 Y 1000

1 Dr 30

2 Dr 30

But i must get as 2 Rows only not 4.

Kumar