Tag Archives: Tabular

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

Table compression test

A bit unexpected result during compression testing: ColumnStore indexes and PAGE compression might outperform depending on data. The only measure stable is load time: 2 hours to load into tables organised as ColumnStore indexes versus 1 hour to load into the … Continue reading

Posted in Administration | 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

Effect of case insensitive Tabular database

Source data: Processed table: Pretty well described here: http://blogs.msdn.com/b/cathyk/archive/2011/10/24/making-tabular-models-more-sensitive.aspx

Posted in programming | Tagged | Leave a comment

Row- and role-based security model in Tabular modelling

    The goal is to control access level basing on a hierarchy on per-node basis. Another restrain is that each user may need access to multiple nodes (this complication impedes from using of DAX-function LOOKUPVALUE). Natural hierarchy consists of … Continue reading

Posted in programming | Tagged , | Leave a comment