Infoset Nav Attribute problem

[gunesbt]

Hi all,

I created an infoset containing activities cube(0csal_c01) and 0cust_sales. See the attachment please.

What I want to do is joining 0crm_Salorg in the cube and 0salorg of 0cust_sales but I can not do that because their format are different.So I activated the attribute salorg of 0crm_salorg to join 0cust_sales__0salorg.But it does not appear in the infoset since 0crm_salorg is a time dependent characteristics.

Adding 0salorg ruins my modelling(or I could not achieve to model this in infoset) What can be done to join 0cust_Sales__0salorg with the cube?As you see the key field 0salorg is free and this affects the values in the report.

[amine_lamkaissi]

Hi,

Ensure that the infoobject 0SALORG has a reference char  0ORGUNIT as 0CRM_SALORG.

I think that your issue will be solved.

Amine

[gunesbt]

Hi Amine,

That's why I can not join using 0salorg and 0crm_Salorg.Since 0crm_salorg is an orgunit but 0salorg is not an orgunit(it is not referenced by 0orgunit, it has its own master data table)

Could you elaborate, I don't understand what I should do.

[amine_lamkaissi]

Send me a screenshort of the error that you are getting as i can see what happens?

Amine

[gunesbt]

Hi Amine,

That is the screenshot.This error is due to their master data table.The tables have different values so I can not feed from one other.

[anshu_lilhori]

Hi,

Refer the below thread :

http://scn.sap.com/thread/3279142

Hope this helps.

Regards,

AL

[gunesbt]

Hi,

Thanks for the thread.

I dont get any error while activating, I just can not even link those sales orgs(0salesorg in 0cust_Sales and 0crm_Salorg in 0csal_c01) So there is duplicate data in the report.

[amine_lamkaissi]

Hi,

The error is clear.

the two objects that you try to link must have the same technical properties (data type, internal length and number of decimal places)

Try to make them similar.

Amine

[gunesbt]

Yes this is the problem.I am searching another solution like adding 0salesorg to infoset but could not modelled it.Since the values in the master data are different, I can not make them similar.

[amine_lamkaissi]

But be carefull, If the data is different between the 2 infoobjects your join will never work and you will not get the desired data.

Amine