cancel
Showing results for 
Search instead for 
Did you mean: 

IBP Excel Case Sensitivity

philj82
Discoverer
0 Kudos
88

Hello

I am experience a strange behaviour in the Excel add-in for IBP. Here is the scenario

A Product description has been created in ECC in mixed case. In this example, the description contained the letters Mg. In subsequent days, the masterdata was updated in ECC to be MG.

Whilst the master data in IBP updated to reflect this, the excel add-in remained as Mg.

However, if I made a significant change to the masterdata (I added a 1 at the beginging) then the fully updated description with MG appeared in excel. 

To make this more mind-blowing, when I removed the 1, the case went back to Mg.

It wouldn't be a huge issue, but for the fact that the case sensitivity means that the planning object cannot be found, and so causes an error in the excel add in when updating a key figure.

Any help appreciated!

View Entire Topic
peter_casper
Contributor
0 Kudos

Hi @philj82,

did you try to to clear the metadata cache before connecting to IBP? I am curious if the experienced behaviour is still present.

BR, Peter

philj82
Discoverer
0 Kudos

Hi Peter
Do you mean here, the clear cache button?

philj82_0-1732876006362.png

 

philj82
Discoverer
0 Kudos
Unfortunately that didn't make any difference