Hello,
there seems to be a problem with data sources that have a one to many relationship.
I created a dashboard showing a ranking of order entry by product (Artikel) as funnel chart and data table at the top.
The table below displays order details by product. All elements are members of the same group.
See screenshot OneToManyRel_01.JPG
The ranking relates to data source DSRankingArtikel (ranking by product).
There is definitely only one record for each product identified by article Id (ArtikelNummer).
The data table for order details by product relates to data source DSOffeneAuftraegeArtikel.
There can be many records for each product identified by article Id (ArtikelNummer).
I also created a data relation to link the two tables by attribute "Artikelnummer".
Screenshot OneToManyRel_03 shows the relation between DSRankingArtikel and DSOffeneAuftraegeArtikel by column "ArtikelNummer".
The result is not what I would expect.
Whenever there is more than 1 record in the result set for order details, the values of all measures (i. e. AuftragsWert (total order value)
in the table for rankings are multiplied by the number of records in the related table.
Screenshot OneToManyRel_02.JPG depicts that behavior: the total of values in column Pos.Preis should equal the value in column AuftragsWert.
It shows three times the value instead.
When measures are changed to dimensions, correct values are shown.
Screenshot OneToManyRel_04 shows the correct value for total order value (AuftragsWert) as it exists in data source DSRankingArtikel.
What am I getting wrong here?
Working with one to many relationships in dashboards is a key concept for us, so we need to get this work.
(Support ticket related to this posting: 3159758)
Regards
Ralf
One to many relationship in dashboard not working
One to many relationship in dashboard not working
- Attachments
-
- OneToManyRel_04.JPG (77.63 KiB) Viewed 1983 times
-
- OneToManyRel_03.JPG (97.41 KiB) Viewed 1983 times
-
- OneToManyRel_02.JPG (80.6 KiB) Viewed 1983 times
-
- OneToManyRel_01.JPG (270.45 KiB) Viewed 1983 times
-
- OffeneAufträgeRankingNeu_FehlerRelationOneToMany.mrt
- (86.71 KiB) Downloaded 119 times
-
- OneToManyRel_04.JPG (77.63 KiB) Viewed 1986 times
-
- OneToManyRel_03.JPG (97.41 KiB) Viewed 1986 times
-
- OneToManyRel_02.JPG (80.6 KiB) Viewed 1986 times
Last edited by Ralf40670 on Fri Aug 02, 2019 8:45 am, edited 4 times in total.
Re: One to many relationship in dashboard not working
Hello, Ralf.
There are no screenshots.
We need to reproduce the issue to help you.
Please, send us samples by email.
Thank you.
There are no screenshots.
We need to reproduce the issue to help you.
Please, send us samples by email.
Thank you.