Check this out. I have a transactional datasource that
I had to break out by month. I have 36 months in my database, so now I have 36 transactional datasources.
I am trying to insert these 36 datasources into my Transformer model. It is taking a ridiculous amount of time to insert 1 datasource. I clocked it at about 2 hours just to insert each datasource.
Can anybody help??? Why does Cognos take so long to insert each datasource. I would expect it to take a couple of minutes tops. Not a couple of hours.
I will soon have a Transformer model which will have 108 IQD datasources. That means it will take 27 days to insert each datasource!!! That is crazy if you ask me. Did Cognos really design such an inefficient tool? I've tried their support line, but they've been no help.
Thanks!
I had to break out by month. I have 36 months in my database, so now I have 36 transactional datasources.
I am trying to insert these 36 datasources into my Transformer model. It is taking a ridiculous amount of time to insert 1 datasource. I clocked it at about 2 hours just to insert each datasource.
Can anybody help??? Why does Cognos take so long to insert each datasource. I would expect it to take a couple of minutes tops. Not a couple of hours.
I will soon have a Transformer model which will have 108 IQD datasources. That means it will take 27 days to insert each datasource!!! That is crazy if you ask me. Did Cognos really design such an inefficient tool? I've tried their support line, but they've been no help.
Thanks!