Multiprovider multiple rows to a single row.

[former_member302630]

I am using a multiprovider as a source for a BEx query.

The multiprovider is made on 3 cubes

Cube_A: Role and fields

Cube _B : Role, Transaction, transaction fields

Cube_C : Role , User , user fields.

The output comes as

Role1    #               #        4001 (role field)

Role1   TCODE1 |   #          #

Role1 |  #               User1   #

Is there a way where I can make one row for role1 in which all are populated. This multiprovider contains a dummy keyfigure which has no value.

Role1  Tcode1   User1   4001.

I tried using an infoset. Joined the underlying cubes, but no data comes. Reason

Cube_A contains role as ZFI_*

Cube_B and Cube_C contains role as ZFI_MANAGER.

Regards,

Cleo

[Former Member · Accepted solution]

Hi Cleo,

In multiprovider identify characteristics, select role from all 3 cubes but select only the relevant cube for the remaining characteristics and check.

example

(cube 1)Role1    #               #        4001 (role field)

(cube 2)Role1   TCODE1 |   #          #

(cube 3)Role1 |  #               User1   #

select Role from all 3 cubes

Tcode1 from cube 2, user1 from cube 3 and 4001 from cube1 only.

hope this helps.

BIAPP

[Former Member]

Hi James

Can you tell me how many kfs are  there please provide me the output with minimum selections so that we can conclude on selection i also faces the same issue but we had done concatanation at bo level

[Former Member]

Hi Cleo james

     Make use of constant selection at bex level that could be resolved your issue.

[former_member302630]

Hi Still Chinna and James,

I did try constant selection.

Using that dummy amount Kf, I made selection and included role, transaction and user infoobjects and tried constant selection on all. Still same result.

[Former Member]

James,

Try creating selection for dummy keyfigure and move characteristic Transaction and User under it.Set them as constant selection. Hope this helps.

Thanks,

[ccc_ccc]

Hi James,

Could you please provide same data output.

Thank you,

Nanda

[former_member302630]

Hi,

Role (char)	Tcode(char)	Exclusive (char)	User (char)	Full Name	Role Key (char)	Amount (Dummy Keyfigure)
ZABAP_DEV	#		#	#	Z2	#
ZABAP_DEV	se38	Y	#	#	#	#
ZABAP_DEV	#	#	ABCSE	ABC SEAN	#	#

I require it as

Role (char)	Tcode(char)	Exclusive (char)	User (char)	Full Name	Role Key (char)	Amount (Dummy Keyfigure)
ZABAP_DEV	se38	Y	ABCSE	ABC SEAN	Z2	#

[swati_gawade]

Hi Cleo,

As the fields that you require are not available in all the cubes, the # velue will be displayed wherever data not available.

you can create a new Cube or Master data object where you can look up values from other data flows and create a single row with all the information.

Hope this helps.

-swati.

[Former Member]

Hi Swati,

I tried the same, I made a DSO and in transformation tried to lookup using role table as base and lookingup in USER and TRansaction table. Currently the select query is reproducing zero records because whereas clause has wild characters.

DSO_A/Cube_A contains role as ZFI_* .............(base table)

DSO_B/Cube_B and DSO_C/Cube_C contains role as ZFI_MANAGER.

Since data volume is high in all tables (over 100,000 records everyday), using select..endselect and contains any is giving an alternative not preferred.

[swati_gawade]

Hi Mohit,

what is the logic to map role ZFI_* from Cube A to ZFI_MANAGER in DSO_B/Cube_B and DSO_C/Cube_C?

What is the relationship between Role and user? 1:N or N:N ?

as per the input provided by you, I could come up with following design.

1. Create DSO and keep only role in Key. (if multiple users then user also in key)

2. create transformation from Cube/DSO B Map only role and Tcode

3. create tranformation from Cube/DSO C map user. then using the logic to get matching role in Cube/DSO A create an internal table with entries that could be found in cube/DSO A. Read A and populate role field in corresponding ZFI_MANAGER role in Cube/DSO C

4. Map user1 and field role.

Hope this helps.

-swati.

[former_member302630]

In DSO_A

There are roles which have values like ZFI*, ZMM* etc.

For one record in DSO_A,

Many users in DSO_B or tcodes in DSO_C.

The issue here is select query where clause considering high volume in each table also. Wild card search '*' brings back zero records.