Ok, I think I resolved this issue....with 10.2.2, synonyms can be used as a regular reference. With 11, you need to explicitly indicate the schema it comes from. For example, in 10.2.2, the Schema value in FM is "EDW", which in the EDW schema in Oracle, our table is really a synonym to "EDWB". With 11, we need to use EDWB in the Schema value in FM.
------------------------------
Amy Rivito
------------------------------
Original Message:
Sent: Fri July 19, 2019 10:27 AM
From: Amy Rivito
Subject: Aliases in FM
Hi Denny,
Thank you for your reply. After converting to DQM and verifying with no errors, I'm still getting the same error in Dashboarding.
------------------------------
Amy Rivito
------------------------------
Original Message:
Sent: Thu July 18, 2019 09:00 AM
From: DENNY NAREZNY
Subject: Aliases in FM
@Amy Rivito Hey Amy,
I reviewed the support case you logged and it appears the model is created in CQM mode. When using a CQM package with a dashboard, Cognos will convert the package internally to DQM. That being said, I think the issue is with DQM and not dashboards. Could you make a copy of the Framework Manager model then convert the copy to DQM and validate the model to see if you get any errors/warnings? Also, are you able to publish the DQM model and test using that in a report to see if you can replicate the same error?
------------------------------
DENNY NAREZNY