Line Items that Do Not Need Time Dimension Appear Blank in Grid View for Some Modules
I would like to ask and gather some feedback on the situation I am having regarding the above subject line.
I find it strange that a module which has a line item that does not need a time dimension (it's set to Not Applicable) shows the information and the other module does not.
For example, in module A, I have a line item "CS1", it is a text, and therefore does not need time dimension so I set it to Not Applicable, it is showing the "CS1" on each row, this is fine. However, I also have a module B, which has the same setup as a line item, I also set it as Not Applicable for the Time, but it's NOT showing the information.
This is affecting model optimization since Time Dimension when used increases the size of the module.
In addition, it's affecting the list being generated because I'm using the said line items as well as part of unique identifiers in the schedule I'm generating text files for. A lot of times, I'm getting the error, "A same key has already been added" - it's because the line item in issue does not show the information in the module which causes the information to be not unique.
This is the module that shows the information even if the line items are set to Not Applicable for the Time:
Here's how it looks in the grid view, it has the information for the said line items:
And this is the module where the line items using the same setup as the above Time Scale, they do not show in the grid view:
Finishing this thread with a logical reason why it behaved that way on my model...
All of the comments were extremely helpful, thanks everyone! The DCA was the reason why it was behaving that way.
I have this module called "Control Access" which is for the read/write access for the modules and it has a Time Dimension - "Month".
So naturally, when there is a read/write access restriction, and the line items in the module problem are set to "Not Applicable" time, it could not see it. So the resolution was to remove the read/write access in the specific line items that do not need time dimension.
Indeed, very odd case, if the line item has no dimensions, Summary Method should not affect how it is reflected in the module.
A few things I would try to find the root cause:
1. Ensure your Formula Scope is set to All Versions (if it is set to Current Version in a non-versioned line item - the formula will not work, although this error would not be fixed by adding time dimension)
2. Check the subsidiary view of AAHC line item, and see if the value is at least reflected there both when time dimension is applied and when it is not (this will help to identify if there is a problem with a formula or a summary method)
Please keep us posted, I am very curious to see what the issue might be 🙂