THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

SQLBI - Marco Russo

SQLBI is a blog dedicated to building Business Intelligence solutions with SQL Server.
You can follow me on Twitter: @marcorus

The ultimate Calendar table for #powerpivot (and #ssas, why not)

Boyan Penev announced the availability of DateStream project on CodePlex: it is a data feed that can be consumed by PowerPivot but also to generate a calendar table for any type of usage. Yes, Analysis Services has a wizard, but when you are in a hurry why not simply consume a ready to go data source?

In fact, this data feed is published for free on Azure DataMarket: https://datamarket.azure.com/dataset/1542c52d-d466-4094-a801-9ef8fd7c6485.

I would like to get feedback – in my opinion performance are not very good but hearing words from other users would be nice.

Thanks to Boyan for his effort!

Published Monday, October 10, 2011 3:09 PM by Marco Russo (SQLBI)

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

Tom said:

Hello,

I got the next error:

"BasicCalendarEnglish: The remote server returned an error: (403) Forbidden."

October 10, 2011 2:16 PM
 

Marco Russo (SQLBI) said:

How exactly you've got the error? You were doing what?

Thanks,

Marco

October 10, 2011 2:20 PM
 

Lee Hawthorn said:

This is a nice idea but I prefer to populate my date table from a SQL view.  The server being on my LAN makes it super quick.

This may be a good for people with no SQL server.

Lee

October 11, 2011 2:56 AM
 

Bhavik Merchant said:

Hi Marco,

Same problem here.

1. enter the feed URL and account key. Test Connection is Successful.

2. Go to next screen, it will list the 3 calendar tables available

3. After i select tables, if i try to "Preview and Filter" or "Finish" the wizard it will give 403 error. At this stage you cannot continue.

it would appreacite it if you could also communicate on bhavik.merchant(at)gmail.com - your blog doesnt seem to have a comment email subscritpion. Thanks!

October 19, 2011 7:09 PM
 

Marco Russo (SQLBI) said:

Have you signed up the feed? You should open the URL on your browser and then sign up the data feed before importing it in PowerPivot.

Marco

October 19, 2011 8:03 PM
 

Bhavik Merchant said:

thanks Marco, i forgot to do this :) working now. I agree that it is very slow, but that is a small price to pay i guess!

p.s. comment registration for email is giving this error:

"The administrator has disabled new account creation. Please check back later - or email the administrator - to see if it is possible to register."

October 19, 2011 11:20 PM

Leave a Comment

(required) 
(required) 
Submit

About Marco Russo (SQLBI)

Marco Russo is a consultant, writer and trainer specialized in Business Intelligence with Microsoft technologies. He runs the SQLBI.COM website, which is dedicated to distribute resources useful for BI developers, like Integration Services components, Analysis Services models, tools, technical information and so on. Marco is certified as MCT, MCDBA, MCSD.NET, MCSA, MCSE+I.

This Blog

Syndication

Archives

Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement