Category Archives: programming

5 questions for time limited interview for BI developer position that touch almost all areas related to modern Microsoft BI

1. For example it’s necessary to allow user to input worker’s salary but ensure that it’s in range related to the worker’s category. Ranges for categories are stored in a separate table. Data inserted by using T-SQL. Where is the … Continue reading

Posted in Business Capability, Data to Knowledge, programming, Uncategorized | Tagged , , , , , , | Leave a comment

Restoring objects in SQL Server

This is a code googled in panic after occasional deletion of a stored procedure. Does real magic saving hours of work that could be spent on re-writing:  

Posted in Administration, programming, Uncategorized | Tagged , , | Leave a comment

Querying Tabular model XML/A with XPath

There can be various reasons to extract metadata from Tabular model, for example to compose documentation or logical model diagram. The next collections are useful from architectural point of view: list of dimensions, list of measure groups and measures, list … Continue reading

Posted in programming, Uncategorized | Tagged , , , , , , , | Leave a comment

Concatenating Row Values in Transact-SQL

A useful trick for logging subsystem based on T-SQL: Found here among a number of similar solutions realised various ways.

Posted in programming | Tagged , | Leave a comment

Hidden functionality of LOOKUPVALUE function

Despite described was not noticed a useful trick in functionality of the LOOKUPVALUE function – in contrast to LOOKUP in SSRS (and in probably many other systems) it returns a distinct selection of found values if there is only one value. From … Continue reading

Posted in programming | Tagged , , , , | Leave a comment

Infinite drill-down in SSRS using DAX

Despite SSRS natively doesn’t support infinite drill-down, it can be realised with a help of invisible parameter. The only disadvantage is that the solution requires server-side refresh. After clicking node “1000C110” the report displays it’s children (10001100 – 10001192):

Posted in programming, Visualisation | Tagged , , , , , , | Leave a comment

Simplest Market Simulator on T-SQL

Ten hours of rash and the simplest market simulator is ready! Gracefully composes buy/sell commands list by trend events and perfectly calculates total return of fund, Sharpe ratio and other statistical parameters. This is an example of a task it helps to accomplish: If … Continue reading

Posted in Data to Knowledge, programming | Tagged , , , , , | Leave a comment