basically this is a transactional list wherein attributes are from A to E column. Need to create a hierarchy from A to E then convert these column to time .
Hi @AmruthaB
If you set the time period format to the below that should work or at least did in the quick test I did.
Not 100% sure but this feels like something has changed as importing as column headers always used to be quite tricky.
Andrew
Basically, the list will loaded with the combination of properties, then there will be no column(like list mappings) to map time. so I am missing out in the staging phase.
@andrewtye
@AmruthaB
For performance reasons, you should not load any list using combination of properties, especially a transactional list where the list tends to have many members. Why? Before each member gets to loaded, the Anaplan has read the entire list to see if that combination has already been loaded. Also, having time and/or transactional data as part of the list as a property is very poor architecture. Please review this article explaining the reason why.
Hi everyone 👋 If you build or maintain Anaplan models, you've probably hit the same walls I kept hitting. Some basic questions about a model's structure have no single screen to answer them. You end up clicking through modules and pages one by one, or writing API scripts just to get a list. These were the gaps that…
Hi Everyone, We have a requirement in Anaplan Consolidation & Reporting (Fluence) where the Entity Structure needs to change effective January 2026. The key requirement is that the existing entity structure should continue to be applicable for all reporting and consolidation periods through December 2025, while the new…
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…
