Blog Archives

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

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

New learning material

I have found some new learning material which explains both SSAS and MDX which is very good though I need to deepen my skills. I have some trouble creating the correct MDX-query with parameters in SSRS so hopefully these videos

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

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
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.