Blog Archives

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/ Advertisements

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

Create goto reports in SSRS with cube as source.

So, I have found some information on the web about this but mostly people tend to use regular SQL, I really can´t understand why. Anyhow here is one way of creating the connection between reports in SSRS with parameters. I

Tagged with: , , , ,
Posted in Report Building

One solution on parameters between reports.

I followed this instructions: http://sqlblogcasts.com/blogs/martinisti/archive/2010/03/31/ssrs-drillthrough-for-ssas-cubes-how-to-pass-a-parameter-to-an-mdx-dataset.aspx to solve the issue with parameters between reports..

Tagged with: ,
Posted in Report Building
Archive
Categories

Blogstatistics
  • 4,124 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.

En smartare planet

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.