Blog Archives

Logical order T-SQL

One very important thing about T-SQL is the way the query operates and in which order the clauses executes. 1. FROM 2. WHERE 3. GROUP BY 4. HAVING 5. SELECT 6. ORDER BY The first one to execute is the

Tagged with: , , , , , , , , , , ,
Posted in T-SQL

Constraints

Here are the constraints used in SQL Server 2012 to help with the integrity problem that otherwise will occur. There are five different kinds of constraints which are used to enforce the integrity of the tables in the relational model.

Tagged with: , , ,
Posted in T-SQL

Plan for certificate 70-461.

So, now I have decided to continue with databases and perhaps in a future the business intelligence path in Microsoft´s certifications. I will start with the “Querying Microsoft SQL Server 2012” 70-461  certificate. I read somewhere that the book “Microsoft

Tagged with: , , ,
Posted in Main, T-SQL

Finally certified!

So, I have finally have my certification with MCTS 70-448: SQL Server 2008 Business Intelligence Development and Maintenance. Now the next step is to make the transition to SQL Server 2012 and I am thinking of taking the path towards

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

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

Links for YTD with new time dimension.

I have found some links that works with the problem of YTD. I don´t know if it will solve my problem but I will post them here so I can go back to it later. http://www.obs3.com/pdf/A%20Different%20Approach%20to%20Time%20Calculations%20in%20SSAS.pdf http://www.bidn.com/forums/microsoft-business-intelligence/analysis-services/1435/ssas-ytd-issue-calendar-vs-fiscal http://cwebbbi.wordpress.com/2006/05/22/multiple-time-utility-dimensions/

Tagged with: ,
Posted in MDX, Report Building

Surrogate key and strange summary with YTD function.

Today I had a problem with a dimension which displayed the transaction numbers in duplicates were I knew there shouldn´t be any. I realised after some searching that the table which resided from the relational source didn´t only used one

Tagged with: , , , , , ,
Posted in Report Building, SSAS
Archive
Categories

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