Alexandru.Rosca
Contributor

ALM - Best Practices

Hi Guys,

我们刚刚开始使用有关Amapedia的文档,并为我们的组织进行了一些测试,因为我们正准备引入ALM(我们已经有了生产系统)。这些是一些初始问题,然后更深入地更新任何引用的公式。如果您可以从您的经验中看出,这将是以下最佳实践。

1.Import model vs Create from revision - assuming we already have the production model, can we make the Initial dev through an import instead? are there any inconveniences when synchronizing further on? I'd choose this as we want to have a 1 to 1 copy with the production, meaning also Production data - I would not achieve it through create from revision tag.

2. How long does usually take for a synchronization (60 -70gb model) - our first test took around 20-25 minutes for just a line item added in one list (is it normal or might be due the fact highlighted above?)

3. How do you bring in Data and MD in your Dev model? We do have daily integration with other systems that populates master data lists and also we would probably need to update Actuals every month - This creates problem if we want to keep 1 to 1 relationship with our dev model, as only production will e updated. Is it a common practice to make regularly copies of the production that will become a new Dev model? Is there an alternative?

5 REPLIES5
anirudh
社区Boss

Hi@Alexandru.Rosca

Great questions!

1.Not at all. The first DEV instance can be a copy or import

2. In my experience, model size is not related to sync times. Best practices suggest moving small changes regularly to reduce complexity and time taken

3. You will have to create a separate set of integrations as well as schedules to keep DEV on par with PROD.

问候,

Anirudh

Alexandru.Rosca
Contributor

Thanks for your feedback and insights.
For the sync part, we only moved a small change (one member in a list), that would normally take 2-3 minutes to make it in production. Doing the sync took around 20-25. Wondering the time would take for much more changes.
As for the integration, that would suit the MD loads, but not actual data inputs in Actuals or forecast, that are done solely in Anaplan Production model.
anirudh
社区Boss

I have noticed ALM syncs taking a long time when they add a significant amount of space to the model, otherwise adding a single line item certainly shouldn't take 20-25 minutes...

关于复制用户输入数据,常规模型副本是完成此操作的最佳方法。

However, there is another approach (which I recommend only as a last resort) to copy over user data inputs from PROD to DEV by making use of the Import Data Sources

1.In DEV, create import actions for all the modules that contain user data. Import from the module line items back into the same module line items

2. Then go over the Import Data Sources tab and edit the source for actions created in (1)

anirudh_0-1594893911694.png

3. By default, the data source will point to the DEV model itself.Change this to point to the PROD model(as the same modules exist in the PROD model, editing the source will work just fine)

4. Repeat creating imports and editing import data sources for all modules which contain user inputs

5.运行导入将导入所有用户数据。将这些操作添加到一个过程中,然后安排此过程将确保始终更新开发模型

问候,

Anirudh

Misbah
Moderator

@Alexandru.Rosca

I have a slightly different answers for you.

1.开发模型必须尽可能精益&小making me inclined towards Create Model from Revision. Having Production Data in your Dev model is not recommended as you might expose your live data to people who you don't want that to see.

2. It depends. If you are pushing multiple Revision tags at once it might take a while but nonetheless it should not take that much time

3. I would keep Dev out of Integration and do that in my Test Env but if you don't have one you can probably test that in Dev and later on mimick it in Prod by changing the WS ID and Model ID in the scripts

Hope that helps

Misbah

nathan_rudman
社区Boss

3: Yes it is a common practice to make copies of prod and use them as DEV, but not really for the reason you are mentioning.

Idieally you'd have your data coming into your data hub and it feeds production. it also feeds the DEV that you can update more or less frequently and with a subset of the data only.


Nathan Rudman, Anaplan Model Builder