Convert dynamic data to static data
If you modify a report, an analysis, or a crosstab
that you do not want to update with changes from the content store,
you can convert the dynamic data items to static by disconnecting
from the content store.
Tip: On the IBM® Cognos® Office toolbar, click the Convert to Static button .
When you convert dynamic data to static data in Excel, any query-related information, such as calculations and filters, is removed from the Microsoft Office document but the data values are preserved.