In FM, is there a way to identify which fields are Primary Keys? In my model, I'm working with data views not actual tables. Just didn't know if I could find the PK using Cognos FM or if I'd have to go back into the views themselves (like with Oracle Toad) and look for them that way.
I cannot recall with Oracle, but with SQL Server at least views don't have keys.
You can mark columns as identifiers, but I am wondering if there is more to this. Is there a specific problem you are trying to solve?
just wanting to identify PKs in my FM model so I can hide a few of them when I push a package out. In Framework Manager, is it the PK that has the different icon than the other query subjects and objects? see screenshot.
That is an identifier, to use FM parlance. Usually that is your primary key(s). But, FM does not always get that right, so I would verify.
great, that's helpful. I'll have to look at that and check with my dba guys
That icon indicates an identifier which means it could be a PK, any field on which there is an index, any Date field and a few other cases. For hiding the keys, you can check the data. If it is not the IDs or the Codes then you can hide it. Basically, any field which the user would never need to see like any surrogate keys regardless of whether or not they are PKs or FKs.