It's all about the answers!

Ask a question

Insight (or) RTC Report on SCM Baselines

VK L (8177151159) | asked Aug 14 '12, 12:57 a.m.
edited Aug 14 '12, 8:30 a.m. by Ralph Schoon (62.3k33643)
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?


5 answers

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

permanent link
VK L (8177151159) | 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:

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


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


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

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

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