Author Archives: Boris Frolov

Power Pivot in Excel. First look. Part 2

This post is continue of the PowerPivot in Excel. First look Part 1.  Today I will get the currency rate for each transaction that is done not in rubles currency. The rates are entered usually monthly (but there can exceptions), … Continue reading

Posted in Business Intelligence, Database development, SQL Server, Technology | Tagged , , , , | Leave a comment

How to create currency conversion in Microsoft SQL Server Analysis Services (SSAS)

In this post I would like to speak about currency rates calculations in standard dimension model, and in the next post I would return to Tabular model, DAX language and perform the same calculations there. It’s quite a common business … Continue reading

Posted in Business Intelligence, Database development, SQL Server, Technology | Tagged , , , , | Leave a comment

PowerPivot in Excel. First Look. Part 1.

In this post let’s have a look on PowerPivot add-on for Excel 2010-2013. Be aware, PowerPivot is not available for Office 2013 (365) Home Premium, so it was preferable for me to stand on Office 2010 rather than migrate to … Continue reading

Posted in Business Intelligence, Technology | Tagged , | 1 Comment

Date Range in SQL

While creating SQL queries for reports, it’s usually required to get a continuous list of dates for a given period. E.g.: get all dates from 1980 Jan 01 till 2013 Dec 31 (12419 records). In this post I would like … Continue reading

Posted in Database development, SQL Server, Technology | Tagged , | 6 Comments

ERP System Performance: availability and network metrics.

In this post I will finish the ERP system performance block. Today I have chosen topic not directly connected with SQL Server, but it’s rather important for building complete picture of the process. So, we have analyze in details how … Continue reading

Posted in Technology | Tagged , | Leave a comment

ERP system performance. How it works in practice.

As I promised, this post will be dedicated to some real life practice. We’ll try to find the bottle neck in one document save process. The principles and structures for ERP performance were described in the previous posts you can … Continue reading

Posted in Database development, SQL Server, Technology | Tagged , , | Leave a comment

ERP system performance metrics

In this post I’d like to show what performance reports we use in our everyday work to track whether system is ok or not. First section – reports we are receiving on daily basis. Timeout Report. The report consists of … Continue reading

Posted in SQL Server, Technology | Tagged , | Leave a comment