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
(http://C:%5CUsers%5Cvishnupriyam%5CDocuments%5CCognos%20cube%20error.PNG)
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
(http://C:%5CUsers%5Cvishnupriyam%5CDocuments%5CCognos%20cube%20error.PNG)
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.