It's all about the answers!

Ask a question

Insight (or) RTC Report on SCM Baselines


VK L (8177145159) | asked Aug 14 '12, 12:57 a.m.
edited Aug 14 '12, 8:30 a.m. by Ralph Schoon (61.4k33643)
Hi All,
          I am looking at creating a report on the stream-level baselines - displaing basline name,creation date and promotion dates,stream name - should also display the owner and other related info.

Is this possible from RIDW Database? If yes, which table contains the baseline data?

Thanks.

5 answers



permanent link
Junli Wang (5512) | answered Aug 14 '12, 10:54 p.m.
JAZZ DEVELOPER
RTC does not expose baseline information via REST service. please raise enhancement request to RTC, thanks.

permanent link
VK L (8177145159) | answered Aug 15 '12, 2:01 a.m.
Hi Wang,
                 I am not looking at the rest service...I am trying to generate an insight report on SCM baselines and the respective promotion/creation dates at stream level. But, looks like there's no data available in the related tables.
The tables that i am looking at:

RIDW:
D_File_Baseline
F_C_Text_File_VERBSLN_Metrics (and other text file tables that contain VERBSLN in it)

RIODS:
Project_Baseline
File_Baseline
File_Baseline_Activity_Lookup

*When i test the tables, there's a "no data available" message. Please help me in resolving this.

Thanks.

permanent link
Junli Wang (5512) | answered Aug 15 '12, 2:04 a.m.
JAZZ DEVELOPER
Are you using RTC or ClearCase UCM?

Comments
VK L commented Aug 15 '12, 2:14 a.m.

Hi Wang, I am using RTC. And these tables that i mentioned above are from RIDW and RIODS Database.


permanent link
Junli Wang (5512) | answered Aug 15 '12, 2:17 a.m.
JAZZ DEVELOPER
those tables you mentioned only works with ETL from ClearCase UCM, not RTC SCM, because RTC does not provide this data to Insight, there is nothing Insight can do if RTC does not enhance REST service to provide this data.

Comments
VK L commented Aug 15 '12, 2:30 a.m.

Thanks Wang. So, even though the baseline-labels and corresponding details are in RTC, Insight cannot read it. So, is this report possible using Birt atleast? If yes, which tables should be referred to?


permanent link
Junli Wang (5512) | answered Aug 15 '12, 2:45 a.m.
JAZZ DEVELOPER
this is not a reporting tool issue, currently neither Insight or BIRT can get this information, because the data is not available from the source (RTC).

Your answer


Register or to post your answer.