MultiProvider Assignment Identification Issues

[Former Member]

Hi All,

I have been trying to create a Multiprovider over two of Infocubes which are 'joining' on the characteristic Document Number, and have hit a bit of a problem since the two cubes share the same time dimensions, 0FISCPER + 0FISCVARNT, but with dates therein being different.

When I am building the MP it automatically assigns/joins on the 0FISCPER dimension, and does not allow me to report (or filter) on the share data as it sees the fiscal periods as different and produce two separate records .  This means that I am unable to view the data from both cubes in the same record, producing results similar to the following:

Current Results

Doc. No	CHAR1	CHAR2	KF1	KF2
1234567890	ABC	#	1234	#
	#	DEF	#	567

Desired Results

Doc No	CHAR1	CHAR2	KF1	KF2
1234567890	ABC	DEF	1234	567

Can anyone advise if there is a way around this issue (with or without using a Multiprovider)?

Thanks in advance,

Derrick

[former_member182470]

Use Constant Selection on Char1 and Char2 for your both KFs in the Bex Query. Hope you may get single record..

[Former Member]

Hi Guys,

Thanks for all of your input/advise

I have discovered the reason for my data not joining correctly from the two infocubes, was due to the fact I am using a Multiprovider and it combines the data from the source(s).

The following article has an in depth discussion of the differences between how Multiproviders and Infosets combine data from other InfoObjects, but basically . . .

"Multiproviders do unions, whereas Infosets do joins"

We have now created an Infoset over the two Infocubes, and the data is now joining together as expected.

Regards,

Derrick

[KamalMehta]

Hi Derrick,

You need to have other characteristics in the info cube. You can get the other characteristics doing a lookup based upon document number.

thanks

[former_member202718]

Hi Derrick,

Try this out,

1) Do a look up and Populate the same Date as the other Cube.

Or

2) In the cube Properties if you compress the Data in the cube the you should be able to see the data as required by you.

rgds

SVU

[MGrob]

HI

You need to populate the other characteristic in the cube load if you want to see them the way you show it in you screen. Do you have a DSO before the cube that would allow you to read the other characteristic. Shouldn't be a big deal since they share doc no.

hope it helps

Martin