Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

The layout shows data that aren`t in the infocube

Hi.

I have created 3 layouts with BPS with one selection variable.

When I execute the layout, I filter trow the selection variable for one value that isn't in the infocube but the layout shows some records.

I have tried to remove the records form the layout but they shows again.

Any body can help me?

Thanks in advantage.

Former Member
replied

Hi Javier,

I see 3 possibilities to explain the system behaviour

1. You are using the combination proposal in the planning layout.

2. Some characteristics used in the rows are restricted to one value in the planning package (or level). In the area for new lines the system automatically print out these values to reduce the reduce the amount of work to fill new lines.

3. You are using the Excel In-Place and you have changed some formatting in the Layout Builder. There the system uses dummy data for a preview. Maybe your Excel template contains some of the dummy data. The system usually saves the Excel template without the dummy data but when formatting or the posistion of some column where changed the system might no know the new position to delete the dummy data, cf. documentation

http://help.sap.com/saphelp_nw70/helpdata/en/aa/f73e4045796913e10000000a1550b0/frameset.htm

You can check check the Excel template using transaction bdn1 or oaer (depending of

the release). Use class name = SEM_BPS, class type = OT and object key

= area_level_0-MP_layout where area, level, layout are the technical

names of the planning area, etc. You can display (and down-, upload the

Excel template). One can try to repair the Excel template or update

the layout with the master template and change the formats as suggested

in the documentation.

Regards,

Gregor

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question