Multicube

[Former Member]

I have Cube A which contains key filed 'ID' and contains values 1 to 10.

Have another cube B which contains same key field 'ID' form diff source and values 5 to 20.

So if i now have a multicube on A & B, will i get values 1 -20 and correspoding other fields?

so multicube will it be a union-right?

[maxilopez]

Hi Chris,

That is correct: a MultiProvider is based on a union operation. The following example illustrates the case that you mention, and how the MultiProvider would look like:

Cube A

ID - KeyFigure1

1 - 20

2 - 30

3 - 40

4 - 50

5 - 60

6 - 70

7 - 80

8 - 90

9 - 100

10 - 110

Cube B

ID - KeyFigure2

5 - 1000

6 - 1010

7 - 1020

8 - 1030

9 - 1040

10 - 1050

11 - 1060

12 - 1070

13 - 1080

14 - 1090

15 - 1100

16 - 1110

17 - 1120

18 - 1130

19 - 1140

20 - 1150

MultiProvider

ID - KeyFigure1 - KeyFigure2

1 - 20 - #

2 - 30 - #

3 - 40 - #

4 - 50 - #

5 - 60 - #

5 - # - 1000

6 - 70 - #

6 - # - 1010

7 - 80 - #

7 - # - 1020

8 - 90 - #

8 - # - 1030

9 - 100 - #

9 - # - 1040

10 - 110 - #

10 - # - 1050

11 - # - 1060

12 - # - 1070

13 - # - 1080

14 - # - 1090

15 - # - 1100

16 - # - 1110

17 - # - 1120

18 - # - 1130

19 - # - 1140

20 - # - 1150

I hope this helps you.

Regards,

-

Maximiliano

[former_member205352]

> 
> MultiProvider
> ID - KeyFigure1 - KeyFigure2
> 1 - 20 - #
> 2 - 30 - #
> 3 - 40 - #
> 4 - 50 - #
> 5 - 60 - #
> 5 - # - 1000
> 6 - 70 - #
> 6 - # - 1010
> 7 - 80 - #
> 7 - # - 1020
> 8 - 90 - #
> 8 - # - 1030
> 9 - 100 - #
> 9 - # - 1040
> 10 - 110 - #
> 10 - # - 1050
> 11 - # - 1060
> 12 - # - 1070
> 13 - # - 1080
> 14 - # - 1090
> 15 - # - 1100
> 16 - # - 1110
> 17 - # - 1120
> 18 - # - 1130
> 19 - # - 1140
> 20 - # - 1150
> 
> I hope this helps you.
> Regards,
> -
> Maximiliano

Key figures doesn't show #, isn't it ?

Key figures would aggregate and it would be

5-60-1000

etc

Yes, its union and it will show 1-20 as long you don't restrict it otherwise.

[maxilopez]

Hi Praveen,

You are right regarding the Not assigned sign (#). When it comes to key figures, "0" is displayed instead of "#" in Multiproviders (the sign "#" is shown for characteristics).

However, as far as I know, the aggregation takes place at Query level but not at MultiProvider level.

So, when you display MultiProvider data, you have:

5 - 60 - 0

5 - 0 - 1000

instead of:

5 - 60 - 1000

Notwithstanding, it is true that the Query would aggregate both values in one row.

Regards,

-

Maximiliano