Just looking for advice.
We are running Cognos Analytics 11.0.6 in a Windows Server 2012 Environment and have a Dynamic model built against a relational Oracle database.
We have a good number of reports built, but are adding to the model. Today I added a couple of tables that were not yet in the model, added relationships, tested each, and created/published a package for testing. I asked FM to verify the model and every single relationship (these were there prior to my changes and reports are running correctly, everything fine) is coming up with a BMT-MD-2007 This object has a status of 'Invalid'. Unable to test the object.
I am in the process of opening each relationship and validating without making and changes...good so far. My question is: why would this happen? I have modified this model several times in the last few months and never had this occur before. Nothing new in versions, and the changes I have made to the model (new tables) are sort of isolated and are not touching most of the relationships/tables producing the error. I have further changes to made and certainly don't want to have to do this every time...a lot of work.
Any advice welcome.
Thanks