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/

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

Problem with parameters in SSRS

I have huge problems with sending parameters between reports in SSRS. Here are a thread I have created.. http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/3ecfe927-7b03-4279-92a4-b15e382b8144. The issue with the YTD-function is also not solved so it´s not clear what I should continue with next week. Should I

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

Trouble with YTD

Yesterday I had big trouble with the YTD function. I can´t make it work with my new cube. I wonder if it have something to do with my custom made time dimension. I will continue look into this since it´s

Tagged with: , ,
Posted in SCRUM
Archive
Categories

Blogstatistics
  • 3,676 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.