Cognos Analytics

Expand all | Collapse all

Aliases in FM

  • 1.  Aliases in FM

    Posted Tue July 16, 2019 12:06 PM
    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
    ------------------------------


  • 2.  RE: Aliases in FM

    Posted Thu July 18, 2019 09:00 AM

    @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
    ------------------------------



  • 3.  RE: Aliases in FM

    Posted Fri July 19, 2019 10:27 AM

    ​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
    ------------------------------



  • 4.  RE: Aliases in FM

    Posted Fri July 19, 2019 12:20 PM
    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
    ------------------------------



  • 5.  RE: Aliases in FM

    Posted Mon July 22, 2019 10:28 AM
    @Amy Rivito - Thank you for posting the solution you found!​

    ------------------------------
    DENNY NAREZNY
    ------------------------------