Entity description is not showing up in context bar

[Former Member]

We are trying to extract data from ECC to BW then to BPC for Entity Dimension.

When loading the data from ECC to BW, in the Start and End Routine the code has
been written such way that hierarchy file is created in the backend folder as flat file and
this flat file is loaded to BPC Entity Dimension using the import master attrib
and hier flat file.

After this load completes, the data is futher it is getting
loaded to the Master data infoobject in BW. Then from this infoobject it is
getting loaded to BPC Entity Dimension using import master data attrib and text
infoobject.

Issue is , when we check entity in the context bar in EPM in place of descrption it is
showing the technical name for the new entity created. When we check in the
web, the description is appearing correctly in the entity dimension after the first load.

But after the second load completes or if we repeat the load, description is showing correctly in context bar in EPM.

Even after the we click on refresh metadata in the EPM -> More tab, still the issue remains the same.

[Former Member]

hi Praveen,

You can select to show ID, description, or both to show at the context. have you tried to change that?

or what is the issue? the description not showing after the 2nd load?

It is very unclear in your post.

maybe try supplement it with screen shots?

Andy

[Former Member]

Do you have a description field in the flat file? - Yes

is it mapped correctly in the transformation file? - Yes

[Former Member]

There is a different package(process chain) you need to run to get in descriptions.

/CPMB/IMPORT_DESCRIPT

load master data then descriptions.

have you done that?

Andy

[Former Member]

Hi Adny,

I am loading the data from the BW Infoobject but the /CPMB/IMPORT_DESCRIPT loads the data from flat file?

With Regads,

Praveen

[Former Member]

Hi Praveen,

You said you load from flat file first? then load from info object?

Andy

[Former Member]

Hi Andy,

Hierarchy load is from flat file.

Master data and text from BW Infoobject.

With Regards,

Praveen

[Former Member]

Hi Praveen,

How can you load hieararchy if you don't load master data first?

Please state steps in point format.

eg.

1. load master data from flat file

2. load description from flat file

3. load hierarchy from flat file

4. load from info object

...

...

...

Andy

[Former Member]

Hi Andy,

Here everything is customized :

Example : -

When the new entity is created in R/3, the same is picked up by the infopackage to BW. From infopackage while loading to BW through DTP, there is code has written such a way that when new entity and its hierarchy are loaded to flat file.