Monthly Archives: April 2013

Cannot find rows equal to some number value in MDX filter function.

I had problem getting a particular row from my query when using the filter function with “=”. I wanted to get a row where a particular column had a particular value. select {[Measures].[Internet Sales Amount]} on columns, filter([Date].[Calendar].[Calendar Year].members, [Measures].[Internet

Tagged with: , , , , ,
Posted in MDX

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

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

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

Creating dimensional model

Yesterday I tried to create my starschema with tables from the ERP. It resulted in a very strange cube with measures that was supposed to be dimensions. The dimensions didn´t have any natural hierarchies that I could create. Today I

Tagged with: , ,
Posted in 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.