Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Cognos Data Manager Issue in RI

Questions
Tags
Users
Badges
sasanuru kumar
(31●4●23●19) Aug 09 '10, 3:37 a.m.
Hi All,

I have issue with RI regarding while loading MSP file (XML format) in DB2 using Cognos Data Manager. Here file is inserting data in to 2 tables named as Task and Task_Detail, After loaded first file then data is inserted correctly in both table,ok. When I try to load second file then that data should be inserted if task ID is same or it should be updated for Task ID is same. But it was not happened but data is over written in Task_detail table. So I am unable to maintain history of data. This very critical issue to me, plase help out from this issue.

I appreciate your help in advance.

0 votes

1 answer
6,580 views
0 votes

One answer

Permanent link
Petroula Pantazopoulos
JAZZ DEVELOPER (366●1●2) Jan 31 '11, 4:30 p.m.
Hi All,

I have issue with RI regarding while loading MSP file (XML format) in DB2 using Cognos Data Manager. Here file is inserting data in to 2 tables named as Task and Task_Detail, After loaded first file then data is inserted correctly in both table,ok. When I try to load second file then that data should be inserted if task ID is same or it should be updated for Task ID is same. But it was not happened but data is over written in Task_detail table. So I am unable to maintain history of data. This very critical issue to me, plase help out from this issue.

I appreciate your help in advance.


Each MS project file is a data source, hence it needs it's own resource group in the xdc file. If you define an MSP resource in the xml configuration tool, run the etl, then subsequently modify the existing resource group but make it point to a different msp file, you will not etl new data, rather you will overwrite existing data as it sees it as the same data source.

0 votes

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details

Question asked: Aug 09 '10, 3:37 a.m.

Question was seen: 6,580 times

Last updated: Aug 09 '10, 3:37 a.m.

Confirmation Cancel Confirm