How to Identify that the table is correctly Indexed on the database ? What we have to take care about proper indexing ?
I think there is no means to check that in RN. U can only check it by executing a report based on the indexed table...
Srik.
Look in the "model.xml" file of your FM project.Ã, The indexes should be in there...if they aren't, make sure you have saved your model then look again.Ã, Do a search for the word "index" and from there you can see how they are laid out.Ã,Â
l always make sure all the indexes are recognized by FM before I start editing the metadata, because I found that the only way to get indexes recognized by FM is upon importing the object.Ã, Cognos has confirmed that this is a bug.Ã, We use Sybase, if that matters.
Annette
Quotebecause I found that the only way to get indexes recognized by FM is upon importing the object.Ã, Cognos has confirmed that this is a bug.
Can you clarify the above statement, we need to import the metadate before we get to do anthing to it, so I do not follow your point
Thanks
If there is any index found by CRN than it can be found there..
ReportNet uses indexes in order to define the unique identifiers....
Elisha...
Just curious.. Why do you want to know if the table is correctly indexed? Indexes are used for defining identifiers but you can set them manually too...