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
Original Message:
Sent: Tue July 16, 2019 12:06 PM
From: Amy Rivito
Subject: Aliases in FM
Hi all,
When attempting to create a dashboard, I'm getting this error which I believe is related to shortcuts and aliases in our FM model
The relation 'T_DATE_DIM' could not be found in the model. Reason: 'XQE-MSR-0023 'T_DATE_DIM' needs to be in the imported schema 'EDW' in the connection 'Enterprise Data Warehouse DWHPREP' in the data source 'Enterprise Data Warehouse'.'
"Path parameter ID does not represent a valid parent" is in the XQE log. The package works fine in Reporting or when I use a non-aliased field in Dashboading.
I have a case opened with IBM, but you know how that goes...
Thanks in advance.
------------------------------
Amy Rivito
------------------------------
#CognosAnalyticswithWatson