Monthly Archives: May 2013

Some random thoughts on my BI-project.

So, now I have done about 80 percent of my project time. I have gone from not knowing much all about SSAS properties and how to create cubes with dimensions to having created some smaller cubes from different relational databases

Tagged with: , , , , , , , , , , , , , , ,
Posted in Future thougths

Links for YTD with new time dimension.

I have found some links that works with the problem of YTD. I don´t know if it will solve my problem but I will post them here so I can go back to it later. http://www.obs3.com/pdf/A%20Different%20Approach%20to%20Time%20Calculations%20in%20SSAS.pdf http://www.bidn.com/forums/microsoft-business-intelligence/analysis-services/1435/ssas-ytd-issue-calendar-vs-fiscal http://cwebbbi.wordpress.com/2006/05/22/multiple-time-utility-dimensions/

Tagged with: ,
Posted in MDX, Report Building

Surrogate key and strange summary with YTD function.

Today I had a problem with a dimension which displayed the transaction numbers in duplicates were I knew there shouldn´t be any. I realised after some searching that the table which resided from the relational source didn´t only used one

Tagged with: , , , , , ,
Posted in Report Building, SSAS

Enhance the reports.

I have found a great link with some enhancements for the report, just some tips and trix which makes the report to get a more professional look.   http://www.mssqltips.com/sqlservertip/1329/drill-down-techniques-in-ssrs-with-the-visibility-property/ http://www.mssqltips.com/sqlservertip/2757/ssrs-textbox-tips-and-tricks/ http://www.mssqltips.com/sqlservertip/2926/ssrs-data-specific-report-drill-through-to-bing-maps/ http://www.mssqltips.com/sqlservertip/2649/creating-a-reporting-service-report-template/

Tagged with: , , , ,
Posted in Report Building

Useful links creating reports SSRS 2008

Set interactive sorting in table: http://www.bidn.com/blogs/Daniel/ssas/1820/ssrs-change-the-interactive-sort-default-to-descending   Nice tutorials on SSRS stuff: http://www.codeproject.com/Articles/195017/SSRS-Series-Part-II-Working-with-Subreports-DrillD

Tagged with: , ,
Posted in Report Building

Working with parameters in SSRS from SSAS cubes.

From the beginning of my project and after I had learned some MDX I realised that not many people on the web are working with SSRS + SSAS. Most of them (including Pluralsight´s instructors & Roopesh Babu, http://www.youtube.com/watch?v=PZM1NL6_H_0 which both is great

Tagged with: , , , , , ,
Posted in Report Building, SSAS
Archive
Categories

Blogstatistics
  • 3,792 hits
Boyan Penev on Microsoft BI

This is my journey towards greater knowledge with Microsofts Business Intelligence Solutions.

Sherry's BI Corner

All about Microsoft’s BI Platform (SQL Server, Reporting Services, Analysis Services, Integration Services)

Sherry's BI Corner

This is my journey towards greater knowledge with Microsofts Business Intelligence Solutions.

Comments for CALUMO

This is my journey towards greater knowledge with Microsofts Business Intelligence Solutions.

True Tiger Recordings

This is my journey towards greater knowledge with Microsofts Business Intelligence Solutions.

Data Inspirations

This is my journey towards greater knowledge with Microsofts Business Intelligence Solutions.