Complex sets

A difficult chapter with lots of function to help build more complexed sets. The Order-function which order the result in DESC/ASC or BDESC/BASC which means that they don´t care if the result is ordered higher up in the hierarchy. To restore a set to its natural order you use the Hierarchize-function. To retrieve the first or the last in a set, use the TopCount or BottomCount and specify how many you want to show. A filter can be used to filter a set and have similar function like a where-clause. The function NonEmpty can be used if you want to exclude empty tuples from a set. Then there are three functions that can work with the set to compare different sets, “Union” (merge two sets), “Except” (identify what is one set compared to another) and “Intersect” (identify tuples that exist in both compared sets). The “Generate”-function works like a foreach-loop that takes an expression and evaluates that on a collection of sets (do something every iteration). The “Extract”-function can be used to extract member references to form a new distinct combination, good to use when you want to drill down to something and “loose” the previously “higher-level”.

Now i will continue with some aggregations.

Advertisements
Tagged with: , ,
Posted in MDX

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Archive
Categories

Blogstatistics
  • 3,680 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.

True Tiger Recordings

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.

%d bloggers like this: