sql server data warehouse: Using Non Common Dimensions within a Virtual Cube -- sql server data warehouse

Using Non Common Dimensions within a Virtual Cube

toddack NO[at]SPAM hotmail.com
11/17/2003 6:32:23 AM

sql server data warehouse: We have this virtual cube that has a dimension that is in common with
several cubes. What we need to happen is to create a virtual cube
bringing in several of the dimensions unique to each cube. This is not
a problem, the problem is what we would like to see happen is when we
make a change to that unique dimension for all the data from multiple
cubes to be updated based on the common dimension and all the
measures.

Re: Using Non Common Dimensions within a Virtual Cube

Mark Andrews
12/6/2003 9:52:59 PM

If you are asking how to make measures work correctly in a virtual
cube when someone tries to filter based on a value which are not
present in the underlying cube for that measure then the answer is to
wrap your measurement calculations in the ValidMeasure() function.

Mark

[quoted text, click to view]