Felicia,
The "Out of memory" error is just that, your machine does not have enough memory to retrieve all of the requested records and it is failing. If you have access to a machine that has more memory that is one way to solve the problem, if not you can use data securities as a workaround.
Data securities allow for both row level and field level security and are applied at an information source level which means
that all saved views for the information source will have the
securities applied. If you hide particular fields from a saved view all
of the saved views based on that information source will not see these
fields. We are going to use it as a way to limit the number of fields
we pull back form the database to lower the memory consumption. This method is best used to get your answer for your view and
then reset it back to show all fields after you are done analyzing. Once again this is simply a workaround for running out of memory and even after doing this your system may still not have enough memory.
Verify you have rights
To do this you must have manage rights for the information source with which you are working. If you do not have the ability to set information source security you need to contact your administrator and have these boxes checked for you.
- Under the Tools tab, in the Users group click Users.
- Under the Users tab, in the Security group click Information Source.
- Locate the desired information source and Check both boxes.
- Click OK.
Apply Data Securities
To set data securities for a view do the following:
- Open the view that you are trying to load.
- Under the Tools tab, in the Users group click Data Security.
- Select your username from the list.
- Under the Fields tab only have checks in the boxes of those fields that are required, the more fields the more memory required.
- Click OK