I am being asked to create a data dictionary. The Gen CSE has all the information i need, before reinventing the wheel, I wondered if anyone else has done this thru SQL?
On the CSE you can also utilise the PI views
that can help generating some queries like this (ENT to ATTR)
left outer join dtxt txt
on txt.text_obj_id = attr.id
and txt.text_model_id = attr.model_id
where mdl.name like <filter by model naming std here>
and attr.model_id = mdl.id
and ent.model_id = mdl.id
and attr.parent_entity_id = ent.id
order by ent.name asc, attr.seq asc;
A lot easier than navigating the meta-model
Under the Gen toolset installation "Gen" folder C:\Program Files (x86)\CA\Gen8x\Gen you will find a CSE Reference Help file csref.chm which describes the CSE Schema (SCHEMA & DATA tables).
Also the same content is here on the 8.5/8.6 documentation wikis:
Client Server Encyclopedia Reference - CA Gen - 8.5 - CA Technologies Documentation
Client Server Encyclopedia Reference - CA Gen - 8.6 - CA Technologies Documentation
Not sure if it will have enough detail for you?
Hope it helps.
Please, if Lynn's post helped you resolve the problem, kindly click the 'Mark Correct' on his post.
Thank you Alfred and Lynn! With those 2 answers I should be on my way. We just need to get Cognos setup to read those views. Thanks again!
Retrieving data ...