Transformer Error TR1901

[herrld]

Using Transformer and selecting Run
I get an error at finished. Error below-

(TR1901) There is an error in the expression parser. (Measure) in d:\temp\cubename.mdc

Can someone tell me what this means.

Thanks

Linda

 

[CognosProfessional]

herrld, hope this helps,

TR1901 There is an error in the expression parser [measure] in c:\<path>MDC
when attempting to create a PowerCube in Transformer that contains calculated measures.

Solution:
This error usually occurs when using calculated measures.

1. Confirm that no calculated measures referenced by other calculated measure have been deleted.

2. This error will occur if a calculated measure is based on other measures and the name of any of those measures (or columns) has been changed. In this case the calculated measure is not able to resolve the name change. The calculated measure should be updated to reflect any changes in name of the measures that the calculation is based on.

3. If a Powercube contains a calculated measure but the measure it is based on has been excluded from that Powercube may also cause this error.

4. Make sure that the properties of the columns used as measures are set to numeric datatype.

5. When generating calculated categories, when selecting 'Single Category', drag the category from the dimension diagram. Do not type it in manually. This will insert the full qualified name within double quotes.


CP

 

[einyel]

Check also or try the measure to be 64-bit floating point on the measure properties.

Angel

Einyel
Functional&Technical Cognos Consultant