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

MDX First week summary

My first week of learning MDX comes to its end. Sometimes i think i understand everything about it but the next moment when i should write a query it´s very difficult to begin. I guess i need more training, which

Tagged with: ,
Posted in MDX

Calculated Members etc.

Today i have learned of calculated members and how the are created. You use the “With Member” – clause to begin creating a calc member. Then write the name and where it should be placed and also where it derives

Tagged with: , ,
Posted in MDX

MDX Query Editor & Tuples

Today i started to write my first MDX-code and read about tuples. Some important things: – Each attribute-hierarchy within a dimension of the cube forms an axis. Along each axis the associated attribute-hierarchy + (All) Member occupies a position. –

Tagged with: ,
Posted in MDX
Archive
Categories

Blogstatistics
  • 4,231 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.

En smartare planet

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.