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

TR2763 error in Cognos Transformer

Started by Vishnu Priya, 09 Jul 2019 01:58:57 AM

Previous topic - Next topic

Vishnu Priya

Hi,

I am trying to create a power cube using report data source. I have used 2 queries one for the measure and the other as a dimension query. The fact table also has columns associated with the dimension and have also checked the scope of the dimension.
But I still get the following error while trying to create the cube: TR2718 Dimension <dimension_name> has no measures associated with it. During PowerCube generation, no query will be able to provide data for this dimension.

Can anyone help on what would be the issue or where I am going wrong. Thanks in advance



MFGF

Quote from: Vishnu Priya on 09 Jul 2019 01:58:57 AM
Hi,

I am trying to create a power cube using report data source. I have used 2 queries one for the measure and the other as a dimension query. The fact table also has columns associated with the dimension and have also checked the scope of the dimension.
But I still get the following error while trying to create the cube: TR2718 Dimension <dimension_name> has no measures associated with it. During PowerCube generation, no query will be able to provide data for this dimension.

Can anyone help on what would be the issue or where I am going wrong. Thanks in advance



Hi,

I'm guessing your transactional data source (the one with the measures) doesn't have a column associated with a unique level in the dimension? That's often the cause of this error...

MF.
Meep!