Hi

In the Analysis Manager, they have already created
specific Time dimension structure. However, if I would
like the structure to be

Year>>Bimonthly>>>monthly

Is there a way to do it?

Freger

Hi,

as first of all, don't use the AS functionalty to create date dimension.
Do it yourself.
Read a very good article about it that Tom wrote:
http://www.sqljunkies.com/Article/D1...D60951395.scuk

But the problem you'll find is that you won't be able to define the level
type as bimonthly, because it does not exist.
Another but, this definition of level type, you'll need it only if you are
plannig to create some period-to-date measures.

Hope this helps.

Peace,
Andrej


"freger" <anonymous (AT) discussions (DOT) microsoft.com> wrote