problem with attribute type in replacement path in bex.

[Former Member]

Hi ,

Thank you for the post  and looking forward to use this. I  am having some problem in 0bpartner . I have used this in my existing cube as a navigational attribute and my requirement in the query is to use BP_type with 0030.when I am creating a formula variable and using a replacement path with attribute type with bp type.it throws a error terminate: system error in program SAPLRRI2 and form CUNM_CUVL_GET-01.

kindly help me in this regard as iam stuck with this problem since three days.

[Former Member]

Hi Mohammed,

For a MD attribute replacement path it needs to be a certain data type. It looks like the values may not be valid. If so please check OSS note 1384942 - 'Numeric variable with replacement from KEY intensified'. it should be a BEx FE patch.

Hope that helps,

Thanks

[former_member182516]

If i understand your query properly ---> Change the BP_TYPE to navigational Attribute and restrict the BP_TYPE =0030.

Hope this will solve your issue.

Regards

KP

[arjun_subhash]

Hi,

I have few doubts:

1. Is BP_type an attribute of 0bpartner?

2. why are u using a formula variable with replacement path for a characteristic which doesnt seem to be usable in any calculation? Are you sure u need to use formula variable or characteristic variable with replacement path?

regards

Arjun

[Former Member]

Hi arjun,

Bp _Type is attribute of 0bpartner.

my requirement is to show some list of offices which maintain in bp type 0030.and i dont think so that we can restrict an attribute in free characteristics.so thought to use formula variable with replacement path and later on put a condition which shows only those records = to 0030.

if u have some other idea then let me know.

Thanks.sharin

[P095090]

HI Sharin,

Please ensure that the values in BP_TYPE are of numeric type,while defining formula variable you have to ensure that the numeric value is returned and is also attached with a unit/Amount/time/date etc/

BR

Surbhi

[Former Member]

Hi surbhi,

i know that values are in of numeric type and the data type for the bp_type is Char and its maintained in standard transformation and infoobject.do i need to change this numc, if so then it;s not allowed to do so.i have to delete the datas.

[Former Member]

Hi Sharin,

You can achieve this with combination of Restricted Key figure with caculated KF.

1. Create a Restricted KF - You can select any KF  and restrict it with BP_TYPE.

2. Assign it to CKF  and select  Exception Aggregation as Count of unique values with BP_TYPE as a  reference characteristic.

Hope this will solve your requirement.

Thanks,

Reshma M.

[Former Member]

Hi Reshma,

I have tried to create a RKF and but it could nt restrict as bp type is attribute .

Thanks

Md.Sharin

I

[arjun_subhash]

Hi,

If  u want to add an attribute of a master data into the report

1. Add the master data info object 0bpartner into the info set or multiprovidor which ever is your info provider

2. Load the attribute bp_type into the cube by using the transformation rule"Read master data"

3.You can make it a navigational attribute in the cube. But in your case you have added 0business partner into the cube as navigational attribute which is the main info object and bp_type is an attribute. You need to add bp_type as navigational attribute and separate sid table(x or y table for time independent and time dependent respectively) should get generated. Then you can do individual drill down using bp_type and use RKF. Also make sure you have not checked "attribute only" in the main info object 0bpartner/

regards

Arjun

[arjun_subhash]

P.S its either 1,2 or 3 above

[Former Member]

Hi Arjun,

your second option and third option looks viable and would like if you can guide me in detail.for the third optin i have already used that in navigational attribute but do not understand separating the sid tables.in second option u mean to say that adding a infobject 0bp_type and mapping with Infoobject which exist in DS.ie obpartner.can you please elaborate.

[Former Member]

Hi Sharin,

You can not achive this requirement with bp_type as a normal/display attribute.

Please follow the below procedure.

Add bp_type to your cube . And in tranformation , map bp_type with 0bpartner 'Read Master data' property .

OR

Change bp_type to navigational attribute. You can do this in attributes tab of 0bpartner. After this,

please check bp_type nav.attribute in Cube and in Multiprovider.

Please uncheck "Attributes only" check box in bp_type info object properties ( General tab) .

Once you are done with any of the above process, you can use bp_type in query restrictions.

Thanks,

Reshma M.

[arjun_subhash]

Reshma did it for you...

[Former Member]

Hi reshma,

idid the same  for second option but it is of no use,i have made bp_type as  nav attributes and uncheck the attributes only.but still iam nt able to use in restriction.

let me try the first option.

Thanks and Regards

Md.Sharin

[Former Member]

Hi Sharin,

Makesure you have selected Nav.attribute in Cube and Multiprovider.

Sometimes your bakcend changes won't reflect instantly in Bex . So first generate query in RSRT and then try with changes in Bex.

Thanks,

Reshma M.

[former_member182516]

Hi Sharin,

It should work, don't know why u r not able to See it even after the attribute is made to Navigational attirbute.

I guess u might be referring to the same Query even after u had changed to navigational attirbute, first u need to regenerate the query and later use it or try to create a new query on the top of the info provider.

In your case navigational atttribute will solve ur issue.

Regards

KP

[Former Member]

Hi reshma,

Finally i have to use the io bp type read from the master data.and now it works fine.but there is one problem persist that bp type has value maintained like 0010,0020,0030,and 0040.and it has text /desciption mainatained like 0030-govt,0040-railways and 0010 - normal.no wthe functional wants the description of that code.and i dont think so this description is maintained in 0bpartner master data.if u have any idea then elighten me.second thing the text/description are maintained in table TB004t under text 40 field.so is there anyway i can map this .

Regards

MD.Sharin

[Former Member]

Hi Arjun,

Finally i have to use the Info Object BP_type independently  as read from the master data in cube.and now it works fine.but there is one problem persist that BP_type has value maintained like 0010,0020,0030,and 0040.and it has text /description maintained like 0030-govt,0040-railways and 0010 - normal.now the functional wants the description of that code.and i don't think so this description is maintained in 0bpartner master data.if u have any idea then enlighten me.second thing the text/description are maintained in table TB004t under text 40 field.so is there anyway i can map this or achieve this.

Regards

MD.Sharin

[Former Member]

Hi Sharin,

You can directly access Text of BP_Type in Bex query. Select the BP_TYPE in your query and in properties of the charactesrictis select dispaly as 'Text'.

Thanks,

Reshma M.

[Former Member]

Hi Reshma,

I already did this and it doesn't display the text .any other way out.why is nt showing?

[Former Member]

Hi Sharin,

Have you maintained text for BP_TYPE ?. Please actiavte data once and genertae query in RSRT.

In RSA1,in  BP_TYPE Bex properties change display type to Text OR  in query designer, for BP_TYPE, select Text and uncheck Standard display properties check box.

It should work.

Thanks,

Reshma M.

[Former Member]

Hi Reshma,

Have tried but its not working.also have maintained text for BP_TYPE.

[Former Member]

Hi Sharin,

Normally it should work ,not sure why it is not working in your case.

Are getting key values even if you maintain display property as Text or you are not getting any values for this field?

Please check if you have text data maintained for the values which are executing report.

Thanks,

Reshma M.

[Former Member]

Hi Reshma,

Text ds has been maintained and the values are displaying as 0010,0020,0030,and 0040.it has description like 0010-normal,0030-govt,0040 railway employee.

my problem is with the description.otherwise i can write a routine where it find 0030 ,0040 should write or displays govt or railways.

Regards

MD.Sharin

[arjun_subhash]

is this bp_type io maintained as a main info object with text. does it have a separate master data text table with language key?

[Former Member]

Hi arjun,

yes this bp_type io maintained  with text.and it has separate master data text table with language key?

[Former Member]

Hi arjun,

yes this bp_type io maintained  with text.and it has separate master data text table with language key?

[arjun_subhash]

Then if nothing else is working try loading the description into the cube using "read master data" in the transformation...