-
Does the list use Time as part of the key?
When is this a problem? This is most often seen in a transactional list when creating a unique value for an item to import to a list. Why is this a problem? Thinking about this from a list creation point of view, do you really want to create a new list item for every date, or do you want to create the list item once? If…
-
Does the list use a combination of properties as a code?
When is this a problem? Always. Why is this a problem? This practice taxes the system and leaves you without a code, making it much harder to map data when importing to the list. How to correct: Exception: If there is no code in the source, you'll have to use a combination of properties. This is rare and should always be a…
-
Does the list have a code?
When is this a problem? All lists should have a code. Why is this a problem? A code makes loading and using a list more efficient, so it is best practice to include a code, especially for numbered lists. How to correct: Check source system availability for creating a source code, as this is often possible. If not, you can…
-
Does the list use Properties?
This is a problem when the properties don't meet the following use case needs: * Display Name for numbered lists * Creating actions using numbered lists * Export labels * Facilitating navigation to different dashboards (classic dashboards) * Creating driver and dependent lists Why is this a problem? List properties are the…
-
Are there subsets on larger lists?
When is this a problem? This is a problem when large lists include subsets. Why is this a problem? Large lists that include subsets can cause performance problems. They add aggregations and add to the overall size of the model. How to correct: Instead of a subset, create a separate list. More information: Planual 1.06-02…
-
Does the subset list follow proper naming conventions?
When is this a problem? Naming conventions should be used for all subset lists. Why is this a problem? Subset lists that do not use naming conventions can cause confusion. Without proper naming conventions, it can be difficult to determine which list the subset belongs to. This becomes more important when using the subset…
-
Does the list include a top level when it is not necessary?
When is this a problem? When you have an unnecessary top level on a list that does not need to be summarized. Examples include a transaction list, currency list, or any other list you are using for an indicator where you do not need to see a top level or summary. Why is this a problem? When you have an unnecessary top…