Multiple Hierarchy

#1

I have Time dimension with multiple hierarchies ( Calendar & Financial). I
want to create a calculated members which will give YTD sales. Now I want to
write MDX in such a way that it will work with both Time hierarchies. Is it
possible to do in AS2000 or I will have to write two calculated members one
for each hierarchy.

#2

You could use iif statement to check which time dimension is being used.
That would mean that you have 3 combinations:

a) calendar is not on the (all) level and financial is --- use ytd(calendar)
b) calendat is on the (all) level and financial is not -- use ytd(financial)
c) both time dimensions are on the (all) level --- your choice what to do

MC

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

Quote:

I have Time dimension with multiple hierarchies ( Calendar & Financial). I
want to create a calculated members which will give YTD sales. Now I want
to
write MDX in such a way that it will work with both Time hierarchies. Is
it
possible to do in AS2000 or I will have to write two calculated members
one
for each hierarchy

#3

Chris Webb has an article on that may be of interest to you here:
http://spaces.msn.com/members/cwebbbi/Blog/cns!1pi7ETChsJ1un_2s41jm9Iyg!
379.entry

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

In article <#obwrlv$FHA.2040 (AT) TK2MSFTNGP14 (DOT) phx.gbl>, marko_culo#@#yahoo#.
#com# says...

Quote:

You could use iif statement to check which time dimension is being used.
That would mean that you have 3 combinations:

a) calendar is not on the (all) level and financial is --- use ytd(calendar)
b) calendat is on the (all) level and financial is not -- use ytd(financial)
c) both time dimensions are on the (all) level --- your choice what to do

MC

"Zubin" <Zubin (AT) discussions (DOT) microsoft.com> wrote in message
news:F6595D99-6C1D-48BE-810C-6A3358801EA9 (AT) microsoft (DOT) com...
I have Time dimension with multiple hierarchies ( Calendar & Financial). I
want to create a calculated members which will give YTD sales. Now I want
to
write MDX in such a way that it will work with both Time hierarchies. Is
it
possible to do in AS2000 or I will have to write two calculated members
one
for each hierarchy

#4

I didnt read it all the way through, but as far as I can see, this relates
to the AS 2005 and the original question was regarding AS 2000. Am I wrong?

MC

PS. thanks for the link, seems like a very usefull blog

"Darren Gosbell" <jam (AT) newsgroups (DOT) nospam> wrote

Quote:

Chris Webb has an article on that may be of interest to you here:
http://spaces.msn.com/members/cwebbbi/Blog/cns!1pi7ETChsJ1un_2s41jm9Iyg!
379.entry

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

In article <#obwrlv$FHA.2040 (AT) TK2MSFTNGP14 (DOT) phx.gbl>, marko_culo#@#yahoo#.
#com# says...
You could use iif statement to check which time dimension is being used.
That would mean that you have 3 combinations:

a) calendar is not on the (all) level and financial is --- use
ytd(calendar)
b) calendat is on the (all) level and financial is not -- use
ytd(financial)
c) both time dimensions are on the (all) level --- your choice what to do

MC

"Zubin" <Zubin (AT) discussions (DOT) microsoft.com> wrote in message
news:F6595D99-6C1D-48BE-810C-6A3358801EA9 (AT) microsoft (DOT) com...
I have Time dimension with multiple hierarchies ( Calendar & Financial).
I
want to create a calculated members which will give YTD sales. Now I
want
to
write MDX in such a way that it will work with both Time hierarchies.
Is
it
possible to do in AS2000 or I will have to write two calculated members
one
for each hierarchy

#5

In article <#$d$Ztx$FHA.3048 (AT) TK2MSFTNGP15 (DOT) phx.gbl>, marko_culo#@#yahoo#.
#com# says...

Quote:

I didnt read it all the way through, but as far as I can see, this relates
to the AS 2005 and the original question was regarding AS 2000. Am I wrong?

Sorry, my mistake. I missed the reference to AS 2000, so your original
suggestion probably still stands.

Quote:

PS. thanks for the link, seems like a very usefull blog

It sure is. At least something good came out of my mistake

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Multiple Hierarchy

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

Multiple Hierarchy - 12-12-2005 , 02:22 AM

Re: Multiple Hierarchy - 12-12-2005 , 03:03 AM

Re: Multiple Hierarchy - 12-12-2005 , 06:33 AM

Re: Multiple Hierarchy - 12-12-2005 , 07:06 AM

Re: Multiple Hierarchy - 12-13-2005 , 03:04 AM