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

Problem with parameters in SSRS

I have huge problems with sending parameters between reports in SSRS. Here are a thread I have created.. http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/3ecfe927-7b03-4279-92a4-b15e382b8144. The issue with the YTD-function is also not solved so it´s not clear what I should continue with next week. Should I

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

Creating dimensional model

Yesterday I tried to create my starschema with tables from the ERP. It resulted in a very strange cube with measures that was supposed to be dimensions. The dimensions didn´t have any natural hierarchies that I could create. Today I

Tagged with: , ,
Posted in SSAS

ETL Process

So, I am going to extract data from my ERP system and transform it before creating the cube. The only problem is that the data is already “good” so i don´t know what to do with it in SSIS so

Tagged with: , ,
Posted in SCRUM

Iterative BI-Solution

I have been reading alot about BI-solutions in different Kimball books aswell in Brian Larson´s “Deliviering Business Intelligence” but not until now when reading the book: “Microsoft Business Intelligence for Dummies” have I got a greater and fully concept about

Tagged with: , , , , , ,
Posted in Future thougths, Main, Report Building

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

First scrum

I will not write anything for yesterday bacause i already wrote that in my last post. Today though i will continue with query my ERP system and learn more about the functions in MDX. I will also post some pictures

Tagged with: ,
Posted in SCRUM
Archive
Categories

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