Print Page - Transformer Scope issue (TR2763)

Title: Transformer Scope issue (TR2763)
Post by: velniaszs on 17 Feb 2014 05:15:18 AM

Hello,
Getting an error TR2763 - All dimensions have no measure associated with them.

The test cube I created have only 1 source table ,5 dimensions, 1 fact.
Data source - FM package.
In transformer data sources tab there are 2 data source queries: 1 for fact - Measure_value and 2 - for dimensions.
Please see attached screenshot.

PS if I use 1 data source query it works but idealy we need to use several queries.

Any ideas?

Title: Re: Transformer Scope issue (TR2763)
Post by: velniaszs on 17 Feb 2014 05:15:56 AM

Here is the scope screenshot

Title: Re: Transformer Scope issue (TR2763)
Post by: MFGF on 17 Feb 2014 08:39:45 AM

Hi,

The data sources need values that link them together so that the measure can be used in each dimension. Your Fact data source has only the measure value in it, but it will need the measure value and a linking item for the each of the dimensions you have.

MF.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Transformer => Topic started by: velniaszs on 17 Feb 2014 05:15:18 AM