Best practice to reduce Max Item Number for Entity

Harry Sun

Hi Team,

We created an Entity with Max Item Number = 1000. It is too high.

I want to reduce the Max to 300.

If I want to make this change directly in Production environment, what are the steps?

If I reduce the max from 1000 to 300, do I need to re-run data reader or anything else?

Thanks

Vivek

Hi Henry , Best Practice to always do your changes on Development Version and upload the data model to Production.

Procedure:

1. Backup Cubes:

• Create a backup of the cubes that have the dimension "EST-Supply Point" with the lowest level. This backup will serve as a safety net in case any issues arise during the process.

2. Clear Entity Members:

• Select the entity "EST-Supply Point" and clear its members. This step is crucial to ensure that the entity is in a clean state before making changes.

3. Modify Max Items:

• Once the entity members are cleared, you can proceed to modify the max items as needed. Increase or decrease the value according to your specific requirements.

Caution:

• Avoid clearing entity members without a backup. This action can potentially delete data from the cubes, especially if you are working on planning data.
• Never make direct changes to production data. Always perform modifications in a development environment and then deploy the changes to production.

Hope it helps

Vivek Yagati(Conrad Electronics SE)