Hi, I have an issue in a crosstab I have to create in Cognos Analytics.
The model is a DMR.
The data comes from dimensions, hierarchies and levels from a package created in Framework Manager.

There is a crosstab which is working fine and it has in rows a level from a hierarchy.
The measure is giving correct results for the members of that level.

On the contrary, if I create a new crosstab with the same measure and I put in rows another member coming from a different dimension/hierarchy it is giving the same repeated number for the the members of that level. I mean for all the rows in that column.

I am wondering if the error comes from joins in the model in FM or from the crosstab in CA.

I have tried many solutions but all the time the measure is give a repeating number for all the members in that column.

I am new to DMR models. If anyone could help me please. I really appreciate any advise because I am really stuck with this issue.

Thank you

Repeating values such as that will happen if the query is being projected below the fact grain.   

I think you would need to confirm what dimensions have relationships to your fact and to what level in each dimension.

For example, assume you have a time dimension consisting of years, months, and days.  Assume that you have a fact table which consists of facts which exist at the day level.  Assume you have another fact table which consists of facts which exist at the month level.  Cases like this are scenarios such as actual values versus planned values.  If you tried to have a query with a month-level fact and days you will get repeating values.  If you have correctly modelled, the summaries should not double count.

Thank you very much bus_pass_man for your reply.
I have one question please.
I have checked the relationsships (joins) and they are all related, but where to check in Framework Manager the relation level in each dimension with the facts?

I am lost there and not sure how to check it.

Thank you very much

If you're pulling data from different hierarchies or dimensions, the problem could be that the relationships between them aren't properly defined or that the query is misinterpreting how those should be linked. Check the cardinality and ensure that your joins in Framework Manager are correctly configured to handle the cross-dimension aggregation.