Skip to Content
0
Former Member
Feb 04, 2014 at 08:27 PM

Infoset Scenario

19 Views

Hi,

My understanding is with Info set we can achieve the below requirement.Need expert advise on how to achieve the requirement and what type of join condition can i use

Cube 1

Employee

Region

KF1

KF2

KF3

E1

R1

1000

900

12

E2

R2

2000

2000

14

E3

R3

3000

3000

56

Cube 2

Employee

Role

KF4

KF5

KF6

E1

ROL1

686

401

912

E2

ROL2

636

222

300

E3

ROL3

402

444

500

In report I would like to see data like

Employee

Region

Role

KF1

KF2

KF3

KF4

KF5

KF6

E1

R1

ROL1

1000

900

12

686

401

912

E2

R2

ROL2

2000

2000

14

636

222

300

E3

R3

ROL3

3000

3000

56

402

444

500