The layout shows data that aren`t in the infocube
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.
Gregor Dieckmann replied
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
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.