I just came across this very cool youtube video. I highly recommend you to watch it.




Hi All,
It’s been awhile since I promised to post more about SSIS and SSAS and I haven’t done so :(…been a bit busy lately in the office dealing with Reporting Services issue.
I picked up few tips that I thought worth to share:

  • When you have multiple datasets in your report, make sure you tick “Single Transaction” option in your dataset, otherwise you will receive a call from your DBA telling that you have too many connections 🙂
    So, if you don’t think that option, SSRS will establish database connection as many as your dataset, even you ONLY open the report (not preview it).
  • If you have an expression like below:
    =CountDistinct(Fields!myField.Value, “myDataset”)
    , just keep in mind that the red color part is case-sensitive.

Now back to my promise about SSIS and SSAS:
I am aiming to post example of each task in SSIS 2008 and some explanation with my best knowledge.
As for SSAS – I will try to post some mini example but reflected on real world scenario with SSAS 2008 and exploring new feature.

Till next time.

Hellow…just received email from Microsoft download about long-await SQL Server 2005 SP3, but it still CTP at the moment. Download it from here.

Yesterday, a colleague came to me and said he can run MDX query but can’t see the OLAP database itself on the server via Management Studio. I thought this is strange since he belongs to one of the role on the database. After awhile, another came with the idea which later on solved the issue. Apparently in the role, under “Data Sources” section, the “Read Definition” option is uncheck.
This option is important because without it, the role member can’t read full definition of OLAP database metadata.

Just came across the new SQL Server 2008 features pack. Download it here.
Also there is a new version of OLAP Extension for Excel 2007 just been released on 15th October. You can downloaded from Codeplex.
This new version contains cube search function that search field list and dimension data.



Finally I got a chance to start my own blog –  a place where I can share my knowledge in Data Warehousing and Business Intelligence area, especially with Microsoft BI stack.

Blogging is actually a good way to learn from each other. So feel free to give comments.

As a start, I have several old and recent news around Microsoft BI stack that I think very useful to share:

  1. Report Builder 2.0 has been released on last 17th October. Download it here. The last piece of Reporting Services 2008 that allow developers, power user and  ad-hoc users power to create and publish their own report.  With Microsoft Office 2007 look-and-feel , this tool provides full features or SSRS 2008 – namely: new data layout, visualization and rich formatted text.
    The tool also allow user to edit deployed report directly from report server.
  2. SQL 2008 Cumulative Update 1 can be downloaded from here.
  3. SQL 2008 Features pack – August 2008 can be downloaded from here.
  4. If you are dealing with SSIS 64bits and Oracle, have a look at this post from Eran Sagi. It provides very useful information about problems and solutions.
  5. Jasper Smith has provided us a very useful tool to allow us, especially developer to generate reporting services script. He also developed a tool to generate linked report, which can be found here. Both tools are very useful in order to automate Reporting Services deployment process.

I will be focusing on SSIS and SSAS (OLAP Cube and Data Mining) in my next posts.