J
Janko
Hi all,
hope someone can help me out with my problem.
In SSAS I have a Cube with one Fac-Table and some Dim-Tables. If I go to the
Browser-View and build a Query, i.e. Filter on Buyer and Date, Rowaxis with
Articles and one Value in DataAxis.
Then I would like to receive only the top 25 articles out of my query, which
works absolutely fine (Right click on Article -> Commands and Options ->
Filter and Grouping) - please be aware that this is a german translation, so
it may be different to the english version.
The calculated "Visual Total" for the 25 is a random value and not the
cumulated value of those 25 articles.
It works fine for Top 1, Top 2, Top 5 but with Top 10, Top 25... it does not
work at all.
Has some an idea how to fix this issue?
Thanks in advanced
~Janko
hope someone can help me out with my problem.
In SSAS I have a Cube with one Fac-Table and some Dim-Tables. If I go to the
Browser-View and build a Query, i.e. Filter on Buyer and Date, Rowaxis with
Articles and one Value in DataAxis.
Then I would like to receive only the top 25 articles out of my query, which
works absolutely fine (Right click on Article -> Commands and Options ->
Filter and Grouping) - please be aware that this is a german translation, so
it may be different to the english version.
The calculated "Visual Total" for the 25 is a random value and not the
cumulated value of those 25 articles.
It works fine for Top 1, Top 2, Top 5 but with Top 10, Top 25... it does not
work at all.
Has some an idea how to fix this issue?
Thanks in advanced
~Janko