Blog Archives

Some random thoughts on my BI-project.

So, now I have done about 80 percent of my project time. I have gone from not knowing much all about SSAS properties and how to create cubes with dimensions to having created some smaller cubes from different relational databases

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

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

Last day of report writing.

Today will be my last day of writing my report to sum up my learnings about MDX. It´s been a short intensive period of study and i will surely come back to this topic during the following months. So the

Tagged with: , ,
Posted in Future thougths, SCRUM

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

Report writing

This week i´m going to write my report about MDX and collect information from the ERP. This is not a report in SSRS but a “regular” report/summary about my learnings in MDX. I will also try to get some more

Tagged with: ,
Posted in SCRUM

Sidetrack and solutions

So, yesterday i had huge problems with processing the cube. I got the error: “Can´t find attribute”. My solutions was that i changed the error configuration for the cube when processing to ignore null key error. I don´t know if

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