Hello all,
Hoping someone might have some insight on Cube functionality - not sure if I'm dealing with a data warehouse issue. We track the total count and net change of our donor constituencies with baseline lists (imported as static lists) and dynamic constituency lists. We are moving these count comparisons into dashboard indicators for easier access. However, when we create a widget that filters Constituent IDs by the list, we get a different count than the original static list. Using a widget filter or filtering in the formula gives the same result. Even odder, the count changes depending on which Cube is being used for the widget. The count in Analytics is always less than the count showing in list manager.
Creating a pivot table that filters down to a specific "missing" Constituent ID shows "no results" on the dashboard. Certain IDs show up when changing the Cube. Is this an issue with the data warehouse and what is passing through?
Thanks in advance!
Contributions Cube
Finance Cube
Are you comparing today's just regenerated list to the list count at the time the warehouse refreshed overnight? Data warehouse is typically updated once a day.
I forgot to mention the baseline list is one we imported into List Manager in September. It's static and the contents have not changed since. We've been getting the same incorrect count numbers every day.