If you are unable to create a new account, please email support@bspsoftware.com

 

BMT-MD-2007 on all relationships model after minor changes

Started by Penny, 24 Jan 2018 04:12:52 PM

Previous topic - Next topic

Penny

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