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

Error in report studio report

Started by dsg1, 25 Apr 2008 02:55:07 AM

Previous topic - Next topic

dsg1

We are using DMR model (in FM). We have a dimension table "company". We have two fact tables "journal_line" and "sales_order_line".The fact fields are coming from these two tables.  These two fact tables are joined to the company dimension via another dimension("team" dimension), i.e. not directly joined to company dim. Whenever we are selecting the company prompt(tree) to run the report an erroror is thrown(when using the dimension model......DMR).but when we are using the same relational structure for the report, there is no error.

I am attaching the error screenshot herewith.