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…
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…
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…
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. –…
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.
