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

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Aliases in FM Model

Started by whatever890, 16 Jul 2019 11:03:17 AM

Previous topic - Next topic

whatever890

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.

whatever890

FYI - I figured out the issue.  In 10.2.2, we are able to use synonyms in FM whereas in 11, we are not.  For example, some of our tables reside in EDWA or EDWB (due to our load process, the schema changes monthly) and we are able to use the synonym of 'EDW' in FM.  With 11, we have to use the "real" schema.  Unfortunately, since it changes month to month, we cannot use the EDW schema.  Still looking for a workaround.

bus_pass_man

If I understand correctly, the schema of the data base changes from EDWA to EDWB and then back again every alternate month. 

Put a parameter map macro into the schema property of the data source connection.  This would resolve at run time.

The simplest, inelegant, brute force, thing would just put in a table which will always be in some schema, have it updated each time the schema name changes, and have the macro lookup the table.

There could be more elegant approaches (I can't think up many less elegant than what I've just suggested) which would look up dates and substitute the appropriate schema or something.