Databases and Auto Updating Series

[cmgconsulting]

I currently have a workfile with three sheets. First, is the data at the lowest level (SKU/UPC/Items) - call this Sheet1. Next, is a "lookup list" that is used to populate an auto updating series in the Sheet1 that places each item into a broader group (Group A, Group B, etc). The third sheet is a list of the groups by date and is filled with auto updating series that either use sum, max, or some other metric to populate various measures by the Groups. So for example, suppose there are three items that all belong to Group A. Item 1 sells 20 units, Item 2 sells 30 units, and Item 3 sells 50 units. Group A for this particular time period would be 100 units.

The key here, is that these are all auto updating series because the data is restated each month, and occasionally there are additional items which requires the "lookup list" to be revised, thus updating the Groups data.

This all works fine and dandy right now, however the file is getting very cumbersome (a little over 1gb). I'd prefer not to split it into multiple workfiles. I'm trying to figure out how the Eviews databases work right now. Is there some way I can utilize the database to hold my SKU level data and also automatically update certain series so that my actual workfile only contains the auto updating Group series? Please let me know if this doesn't make sense or if you need additional information.

[EViews Gareth]

Not entirely sure what you're asking, but if you're saying that the SKU level data doesn't need to be used other than as part of a function, then rather than storing it in the workfile, could store it in a database, then in the groups/functions just refer to it directly with something like mydb::myseries

[cmgconsulting]

Can you have an auto updating series within a database?

[EViews Gareth]

Define what you mean by auto updating series.

[cmgconsulting]

Can I have a linked series in a database that gets populated using match merge from some other source?

[EViews Gareth]

page link or database link?

[cmgconsulting]

Whichever works. I just have a series in a workfile that I need to be populated in order to perform a match merge from a database into a workfile. In other words, I have UNITS in a workfile and a unique identifier called BUCKET. In the database, I have UNITS, but it's by ITEM. I want to create a series in the database called BUCKET that is populated using a match merge so that I don't have to update it every time I update the database w/ additional weeks. I will use BUCKET in the database and BUCKET in the work file to perform a match merge in the workfile, summing all of the units for ITEM for each BUCKET. Does that help?

[EViews Gareth]

There's no way to do that. The only thing you can do is have the source data in the database, and a pagelink specification stored in the database. If you fetch the pagelink into your workfile, you will also need to fetch the source data. A database cannot update any links stored in it.