You could do calculated measures like this

([measures].[employee count], [status].[terminated])

and another for:

([measures].[employee count], [status].[active])

Or you could keep it really simple and just use your employee count measure as is - instead...

HI, I hope I understand your question correctly.

Try something like this as your calculated measure: (Assuming your employees dimension only has one level)

Distinctcount(

Descendants([Employees].[all employees], 1))

Hi Steve

I am trying to build it into a calculated measure - I couldn't figure out how to use the "with set" statement in a calculated measure - seems like this is...

I havent' tried this in DTS but it should work: Why not do a union query that unions all the tables - as longs as the data types and sizes...

Have you tried backup and restore. In analysis services on your dev server right click the cube database and shoose something like 'archive database'. This makes a CAB file. On...

Hi Tobi

Not sure about the filtering / incremental updates but do you know about partitions? If you are running the enterprise version you can partition the cube. Use a new partition...

Cool!

Ok, not sure then. Just some other obvious thoughts: Are you sure all the normal cubes the virtual cube needs are fully processed before the virtual process starts? Have you tried...

This is an ActiveX script we run in DTS. Not sure if you can use it in a command file or if it is different for a virtual cube. Hope...

Sorry - missed the error on your first post.

What about this disc filling up at night and clearing space again: e.g. large transaction logs filling up the disc and truncating...

I would right click the SQL Agent service under control panel services and check which windows account the agent is running under. Log into the pc as this account (the one...