Blog Archives

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

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

Can´t open report in SSRS

So i had this problem of open a report in SSRS, getting an error message: [rsInvalidReportDefinition] The report definition is not valid.  Details: The report definition element ‘ConnectionProperties’ is empty at line 8, position 9. It is missing a mandatory

Tagged with: ,
Posted in Report Building

Problem showing column data from SSRS report.

I had a big problem showing data in one column in my report. It showed fine in BIDS but it didn´t show in my external reporting tool, similar to report manager.. I had to do like this: I had to

Tagged with: , ,
Posted in Report Building

Report finished

So, finally my report is finished and i can go on with my project. This week i will start creating reports in SSRS i think and if everything works fine i will look at Excel next week. I will try

Tagged with: ,
Posted in MDX, SCRUM
Archive
Categories

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