Hi,

I have a cube which represents sales force plan and i have a single
time dimension in it. The problem i am facing is that there are some
measure like actual visits which means that visits done by a sales
representative and planed visits means visited that are planed for
future. Now to show planed visits i need to have time dimension members
till future dates where as there are no values on those days for actual
visits since the are not yet performed what i want is to show users
only those days or members of time dimension for actual visits that
have values i.e till today and for planed visits alll future members
should also be shown both measures are of same cube.

can any one help??

Hi,
I had little trouble understanding the issues by I think you should
plan for having two seperate cubes for Acutal Visits and Planned visits
and join then together in a virtual cube.
Dip

Both measures are of same cube means from the same fact table thats what you
were trying to say no? Better solution is create two time dimension like
DIM_TIME_PLANNED and DIM_TIME_ACTUAL and use this to show for respective
palned and actual values.

Thanks,
Sree

"Usmani" wrote: