hi,

can we use calculated members to create a new dimension.
if so, can any one give me the details how to use this.

Thanks in advance.

Sure you can. Let's say you want to add a dimension called 'Time
Filter', that will enable users to see data for the selected period
only and for a YTD for the delected period.

The fact table will only contain the data in the period. Expand the
fact able with one column, containing a key for the time filter
dimension. This key can be anything, just make it 1.

Create the new dimension called Time Filter in AS with the member 1 as
the only member. Use a string in the member key column to give it a
name like 'In the period'.

The create a calculated member in the Time Filter dimension called
Year to date. Give it the following MDX:

YTD([Time].CurrentMember,[Time Filter].[1]) the latter being the 'In
Period' member.

I don't have AS available at the moment to make sure this works out of
the box, but this is the general idea: in every calculated member in
the new dimension, you need to include the 'real' member in the tuple
used in the calculated member.

Does this make anay sense? :-)

HTH,

Coen