FM Query Subject, add Indexing

[cognosehelp01]

Hey guys,

So I have created a query subject in Framework Manager that combines columns from two tables ( a date column from a date dimension table and an object column from an incident table).

It works as it's supposed to, adding a field of dates for every object, only thing is that there doesn't seem to be any indexing so queries last longer than they should. Is there a way to force an index ( I have created a column that combines the object name and the date to create a unique ID). I have set that as an Identifier but that doesn't help speed up the process.

Is it possible to do so, if so how?

Thanks

[MFGF]

Hey guys,

So I have created a query subject in Framework Manager that combines columns from two tables ( a date column from a date dimension table and an object column from an incident table).

It works as it's supposed to, adding a field of dates for every object, only thing is that there doesn't seem to be any indexing so queries last longer than they should. Is there a way to force an index ( I have created a column that combines the object name and the date to create a unique ID). I have set that as an Identifier but that doesn't help speed up the process.

Is it possible to do so, if so how?

Thanks

Hi,

Your metadata model in Framework Manager is simply a description of the underlying tables and columns (which you can then reorganise as desired) but it doesn't physically change the database. If you need to add indexes or change table structures etc, it is done within the underlying database, not from within FM.

Cheers!

MF.