Monthly Archives: October 2014

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): Advertisements

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