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

Oracle Packages in FM

Started by eliza_jane, 21 Dec 2010 12:39:35 AM

Previous topic - Next topic

eliza_jane

I have an Oracle Package created that I need to import into FM. The reason for using Oracle Package is this returns data based on user id. I am using this package as the source for my parameter map to filter query subjects in my model.

The package returns varchar2(1000) data type. The query subject doesn't work for all users. FM throws "UDA-SQL-0283 Metadata describing xxx does not match results from the database". When I looked up the error I found that the data type of the data set returned by the Package needs to be the same in all cases.

My package returns varchar2 data type in all cases, but Cognos shows data type as character length 16 with a precision and size value. The precision and size value differ when I import the package as different users.

Is there any way to avoid the precision and size values or get it to be set the same?