Few words about: hiding shared dimension hierarchies only for one cube

Few words about: hiding shared dimension hierarchies only for one cube

Sometimes, in many scenarios developer must deal with many cubes in the same project and share dimensions between them. IT’s easy to set up something like this but try to imagine situation when one cube musts be browsed by fiscal dates and the others need to use calendar dates. It is not a problem when we don’t have shared dimensions in our solution but for some people it can be when we have shared dimensions. But don’t be afraid – there is very simple solution to achieve our goal.

Let’s look at AdventureWorks Multidimensional project. There are two cubes: Adventure Works and Mined Customers. Both of them use Date dimension – we need to set for Adventure Works to see only Calendar hierarchy and Mined Customers need to see Calendar and Fiscal hierarchies – let’s do this!

First of all open Cube designer of Adventure Works and go to Cube Structure tab. There is dimensions window and there we need to find Fiscal hierarchy:

Cube structure dimensions

The only thing that you need to set up Visible property of Fiscal hierarchy to False.

dimension properties

That is all! From now shared dimensions could be more flexible to use. Thank you!

 

Advertisements

Few words about: Unary operators in SSAS

Today’s topic will be the unary operators in Analysis Services. They allow us to build custom rollup operations in hierarchies. In standard hierarchies, eg. Parent-Child child elements are aggregated to parent with one standard operator defined, in most cases it will be + operator. But sometimes we need to create something custom and then unary operators come up.

Unary operators allow us to build some interesting feature based on dimension table like this:

parent-child-table

This table shows that:

Total=LevelA+LevelB

LevelA=LevelA1-LevelA2-LevelA3

LevelB=-LevelB1

Continue reading