Metrics extract fail when run from Cognos connection

[C8]

Hi,

The problem I am facing is:

Metric extracts published in Cognos connection fail with error: DIS-RUN-3140 Import data from data source into satging area execution failed in package <package name>

This happens only with extracts based on SSAS cubes.
Those based on a relational framework succeed when run in Cognos connection.

However, when the extracts based on cubes area pushed to staging area using Metrics Designer, it succeeds.
Hereon, further processing is possible through Cognos connection.

Has anybody come across this kind of problem? ???
Any help/ advice will be appreciated.

Thanks!  :)

[francois]

Hi, i'm facing exactly the same problem....

Also the problem occurs in my development environment that has been built as a copy of my production environment....assuming the cmmstore was not created using the script. Maybe this is the reason why it's not working ? because it's working under the production one.

Would you tell me more about your install ? db type....company you're working for  ;D