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

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

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

Learning MDX..

I have continued with my report and i have been using my  notes from last weeks to help populate the report. I have learned the MDX functions a bit better but needs to look at it some more. Thinks it

Tagged with: ,
Posted in MDX

Basic MDX-stuff

Today i written alot about basic MDX-stuff like dimensions, the basic statements like SELECT, FROM, WHERE. Some not so standard like topcount, order and so on.. I have i problem with creating a query with a bottomcount and an order

Tagged with: , , ,
Posted in MDX

First summary writing

So, i have started at my report. First things was about planning how the report should look like and what information i need to include. Today i wrote some basic stuff about cubes, Microsoft BI-solution, OLAP and the difference between

Tagged with: , ,
Posted in MDX
Archive
Categories

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