It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Follow this question
Question details

×10,908
×7,383
×4,692
×4,288

question asked: Jan 10 '15, 12:37 p.m.
question was seen: 3,712 times
last updated: Jan 22 '15, 8:06 a.m.

Related questions

FAQ - How this Forum works

When to run Data Mart Collection jobs in RQM?

0
Sarvendra Kumar (19●2●24●26) | asked Jan 10 '15, 12:37 p.m.
The server administration has 2 option of running jobs.
1-Data warehouse collection jobs
2-Data mart collection jobs.

The data warehouse is based on Java ETLs to load data from the application storage to a common data warehouse storage.

The Data Mart says that it only has information about metadata of application, and the reports are not run on this. Then why do we need this Data Mart collection job?
And how does the storing of meta data for an application is justified by running it manually via admin section(I was unable to find out any conclusion)?

Accepted answer

1
permanent link
Francesco Chiossi (5.7k●1●11●19) | answered Jan 22 '15, 5:17 a.m.
edited Jan 22 '15, 5:17 a.m.
Hello Sarvendra,

sure!
See the topic "What is the meaning of 'Data Mart' mode vs 'Data Warehouse' mode on the Reports tab of the JTS Admin UI?" of the following document:

CLM 2011 Upgrade Frequently Asked Questions
https://jazz.net/library/article/679#What_is_the_meaning_of_Data_Mart_mode


The new warehouse covers the entire CLM domain, whereas the data mart covers only the RTC/CCM domain and is primarily meant for those who wish to continue using BIRT with their existing RTC 2.x reports and do not plan to adopt RRDI.  The out-of-the-box RQM BIRT reports do not work in data mart mode.

The com.ibm.teamserver.*.datawarehouse.provider teamserver property values are as follows and correspond to the mode visible from the Reports tab of the JTS Admin UI:

  • Local (Data Mart Mode). This is the RTC 2.x-style behaviour, where the old-style data mart Java ETLs run and store information in the data mart. BIRT reports get their data from the data mart.
  • Remote (Datawarehouse Mode). This is the default on a new CLM 2011 installation. The new Java ETLs run and store information in the new data warehouse. BIRT reports get their data from the data warehouse.  In order to access the CLM data, it is recommended that RRDI be used instead.  If you wish to keep the BIRT reports, it is still possible


Best Regards,

Francesco Chiossi
Sarvendra Kumar selected this answer as the correct answer
Comments
1
Sarvendra Kumar commented Jan 22 '15, 8:06 a.m.

 Hi Francesco


Thank you for providing the answers and being helpful in addressing the query.

One other answer

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Francesco Chiossi (5.7k●1●11●19) | answered Jan 12 '15, 4:48 a.m.
Hello Sarvendra,

my understanding is that the Data mart collection jobs are the equivalent of what was used for reporting in RTC 2.X before the data warehouse was introduced.
I think they are still used only if you choose not to configure a data warehouse during the CLM setup.
If you have a data warehouse they have no use or need to be executed.

Best Regards,

Francesco Chiossi
Comments
Sarvendra Kumar commented Jan 22 '15, 1:04 a.m.

 Hi Francesco, 

Thanks for your reply.
Can we get a documented proof of the behavior somewhere, that will be helpful. 

Your answer

Register or 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.