Analysis Services

BIDSHelper beta released

Chris Webb
Via Darren Gosbell, news that the beta of BIDSHelper has been released:
 
You can download BIDSHelper from Codeplex here:
 
BIDSHelper contains so many cool features that make your life as an AS developer easier it’s untrue. The MDX Script updating (bypassing the sometimes 30 minutes waits I’ve sometimes seen) feature is worth the download alone. Kudos to Darren and Greg Galloway for their work on this.

Published by Chris Webb

My name is Chris Webb, and I work on the Fabric CAT team at Microsoft. I blog about Power BI, Power Query, SQL Server Analysis Services, Azure Analysis Services and Excel.

4 thoughts on “BIDSHelper beta released”

  1. Hi Chris,
    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 ket attribute (\’Date\’ for that dimension) with the correct count, but the other attributes with an higher count:
     
     

    Reply

  2. Hi Paolo,
     
    I\’m not a developer on BIDSHelper, so I can\’t answer this question. Trying posting it on the Discussion Forum on the BIDSHelper site.
     
    Chris

    Reply

  3. Hi Chris,
    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 small 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.
     
    Regards.
    Paolo
     

    Reply

Leave a ReplyCancel reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.