I downloaded and installed bidshelper and I appreciated a lot some features, but I've just a question about 'Update Estimated Count'. Launching this procedure I expect to see all the attributes set with the exact counts within the partition; so, let suppose
to have a yearly partition, in the time dimension I will expect this :
Date <= 365
Month <= 12
Year = 1
In the end of the procedure I see the key attribute ('Date' for that dimension) with the correct count, but the other attributes with an higher count:
Date = 278
Month = 64 (the time dimension has 66 months)
Year = 6 (the time dimension has 6 years)
For the dimension key attribute ('Date') the count is correct, but the 'Month' and 'Year' counts seem to be calculated as the partition contains all the fact data. And for all the other dimensions I have the same problem: the counts are correct for the
dimension key attribute only.
I tried also to create a very simple cube with one dimension and a fact table with 14 rows, but I got the same result.
Where am I wrong?
Many thanks for your time.