unfortunenately I can't upload the file or share a screenshot of the application.
I try to draw it here with a table:
This is how it should look like:
Area-Hierarchy Cat 1 Cat 2 Cat 3 Cat 4
=Count(distinct ArticleID) B e.g. 200 C 400 D 600 E 340 F 802
So this is like it should look like on the access point. And it does look like it should in every file whether its openend locally or through the access point. Even in production path under another name it works fine. The first column is a Hierarchy-dimension. The rest is
a count split up on the hierachy on the left and the category dimension at the top of the table.
But when the file is placed under production path under its correct name it looks like this (although the file just got copy from development to production):
Category Count(distinct ArticleID) (the formula is the heading here) Cat 1 e.g. 5000 Cat 2 4000 Cat 3 3444 Cat 4
If I look up the properties while open it in the access point it shows me that the hierarchy dimension is not there. If I rename the file everything works fine...super weird.