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…
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…
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…
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…
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…
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…
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…
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…
This is my journey towards greater knowledge with Microsofts Business Intelligence Solutions.
All about Microsoft’s BI Platform (SQL Server, Reporting Services, Analysis Services, Integration Services)
This is my journey towards greater knowledge with Microsofts Business Intelligence Solutions.
This is my journey towards greater knowledge with Microsofts Business Intelligence Solutions.
This is my journey towards greater knowledge with Microsofts Business Intelligence Solutions.
This is my journey towards greater knowledge with Microsofts Business Intelligence Solutions.