Good evening, I appeal to you on a subject of fusion between objects of the universe and an Excel source.
On the BO universe side, I also have a DIM0 dimension type object, another DIM1 and another DIM2 information type object. On the other side I have a second Excel source with another dimension DIM1 and another DIM2. The values of DIM1 and DIM2 objects are of the same format. The particularity is that the DIM2 object of the universe is of the Information type and not a dimension.
When I try to merge the 2 objects DIM1 and DIM2, the expected result is not as I wish.
Here is an example :
→ BO source
DIM1 = A1 A1 A1 A3 A3
DIM2 = B1 B1 B3 B1 B2
DIM0 = toto tutu titi tata ruru
→ EXCEL source
DIM1 = A1 A1 A3
DIM2 = B1 B2 B1
** Expected result :
from the common values of DIM1 and DIM2 display the values of dimension 0
DIM1 = A1 A1 A3
DIM2 = B1 B1 B1
DIM0 = toto tutu tata
=> the other dimensions are not common
Use: WEBIntelligence
BI version 4.2 pack3 patch3
Thanks in advance