How to handle large parameter map

[hana00]

Hello everyone,

I have a problem with a parameter map.
My parameter map in Cognos FM need to automatically update when new record will be update in query is database - which is a base for parameter map.
But the query is deffinitely more than 50 000 records and IBM recommends not to creating parameter maps based on queries where number of records is large (more than 50 000).

"Do not base a parameter map on a query item or table with a large result set, such as 50,000 rows. Each time you use the parameter map in an expression or in SQL, Framework Manager executes this large query. Performance is then slowed. Parameter maps should be used for smaller lookup tables."

Please give me advice how to handle a larrge parameter map which need to be automatically update.
Thanks!  :)

[Lynn]

Hello everyone,

I have a problem with a parameter map.
My parameter map in Cognos FM need to automatically update when new record will be update in query is database - which is a base for parameter map.
But the query is deffinitely more than 50 000 records and IBM recommends not to creating parameter maps based on queries where number of records is large (more than 50 000).

"Do not base a parameter map on a query item or table with a large result set, such as 50,000 rows. Each time you use the parameter map in an expression or in SQL, Framework Manager executes this large query. Performance is then slowed. Parameter maps should be used for smaller lookup tables."

Please give me advice how to handle a larrge parameter map which need to be automatically update.
Thanks!  :)

Can you incorporate the table into your model using a join rather than using a parameter map? Maybe you could explain more about the functionality you need so that alternative approaches could be suggested.