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)

Vivek

Hello Henry,

What do you mean by "deploy the changes to production"? 

Yes deploy means , transport the modifications from development to production. This is a best practice to do.

Does it mean I need to re-do the process in the production environment?

No, If you are transporting your latest Data model from Development instance S1 to Production Instance C1. There is no necessity make an manual changes in Production Instance C1.

Regards,

Vivek

Harry Sun

Hi Vivek,

What do you mean by "deploy the changes to production"? does it mean I need to re-do the process in the production environment? or I can transport/push the the modification from development to the production development?

Thanks