Chris Webb's BI Blog

Analysis Services, MDX, PowerPivot, DAX and anything BI-related

BIDSHelper beta released

with 4 comments

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.

Written by Chris Webb

May 15, 2007 at 9:10 pm

Posted in Analysis Services

4 Responses

Subscribe to comments with RSS.

  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:
     
     

    paolo

    October 24, 2008 at 10:20 am

  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

    Chris

    October 24, 2008 at 10:52 am

  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
     

    paolo

    October 24, 2008 at 10:58 am

  4. Ok Chris.
     
    Thanks.
     
    Paolo

    paolo

    October 24, 2008 at 10:59 am


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 3,310 other followers

%d bloggers like this: