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.