Monthly Archives: February 2013

The Member Function

Learned some things about the member function which is a very important thing. It returns a set of members eg. all members stored within a hierarcy. To return all measures associated with a secific measure group, one should use the

Tagged with: ,
Posted in MDX

Tuples & Sets

Today i read some more about tuples and how to create one using reference members. To reference a member by name you use syntax: [Dimension].[Hierarcy].[Member Name] eg. [Product].[Category].[Bikes] To reference a member by key use syntax: [Dimension].[Hierarchy].&[Member Key] eg. [Product].[Category].&[1].

Tagged with: ,
Posted in MDX

MDX Query Editor & Tuples

Today i started to write my first MDX-code and read about tuples. Some important things: – Each attribute-hierarchy within a dimension of the cube forms an axis. Along each axis the associated attribute-hierarchy + (All) Member occupies a position. –

Tagged with: ,
Posted in MDX

Overview MDX

First session with MDX. I am using the “Microsoft Press: Microsoft SQL Server 2008 MDX Step by Step” by Bryan C.Smith. First chapter was a quick tour on the dimensional model and differences between storage on relational data warehouse and

Tagged with: ,
Posted in MDX

Mission

I will create a Microsoft BI-solution at a company as a part of my education at EC Eduction in Helsingborg Sweden where i study towards Object Oriented System Developer. Main language we are using are C#. This blog will go

Posted in Main
Archive
Categories

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