Analysis services parent/child maintenance

#1

Question:

My company is currently a heavy user of Essbase and the primary reason they
don't want to switch to analysis services is because in Essbase there is a
concept of an Outline and the business users make lots of manual
modifications to how individual dimensions rollup (parent/child).

If we switch to Analysis Services what could the users use to maintain a
parent/child relationship of a single dimension? This needs to be an easy
tool.

Thanks in advance,
Mark

#2

Yes definitely. Analysis Services 2005 supports PC relationships. We have
them all over the place.

"Mark Andrews" <mandrews__NOSPAM__ (AT) ddiworld (DOT) com> wrote

Quote:

Question:

My company is currently a heavy user of Essbase and the primary reason
they
don't want to switch to analysis services is because in Essbase there is a
concept of an Outline and the business users make lots of manual
modifications to how individual dimensions rollup (parent/child).

If we switch to Analysis Services what could the users use to maintain a
parent/child relationship of a single dimension? This needs to be an easy
tool.

Thanks in advance,
Mark

#3

Yes, I know parent/child is supported, question is:
Any easy way to manually update and change the data/relationships (similar
to Essbase outline tool)?

"Jesse O." <jesperzz (AT) hotmail (DOT) com> wrote

Quote:

Yes definitely. Analysis Services 2005 supports PC relationships. We have
them all over the place.

"Mark Andrews" <mandrews__NOSPAM__ (AT) ddiworld (DOT) com> wrote in message
news:%23mKdSVnCHHA.4256 (AT) TK2MSFTNGP04 (DOT) phx.gbl...
Question:

My company is currently a heavy user of Essbase and the primary reason
they
don't want to switch to analysis services is because in Essbase there is
a
concept of an Outline and the business users make lots of manual
modifications to how individual dimensions rollup (parent/child).

If we switch to Analysis Services what could the users use to maintain a
parent/child relationship of a single dimension? This needs to be an
easy
tool.

Thanks in advance,
Mark

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

Analysis services parent/child maintenance

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

Analysis services parent/child maintenance - 11-17-2006 , 12:22 PM

Re: Analysis services parent/child maintenance - 11-17-2006 , 04:28 PM

Re: Analysis services parent/child maintenance - 11-20-2006 , 09:35 AM