Re: MS OLAP and Writeback

#1

David,

Although you posted this question to ADOMD.NET newsgroup, I copy the general
Analysis Services OLAP newsgroup, because the question is not really about
ADOMD.NET, but about Analysis Services.

Quote:

I want to build a budgeting cube for write back but when
I have a cube with dimensions other than Star Schema,
consolidated values return errors (#ERR)!

What is the error message that you get if you double click on #ERR. What are
the error messages that you find in the Application section in NT Event Log.
What is the data source provider (i.e. SQL Server, Access etc). Is this
dimension marked as changing or non-changing ?

Quote:

Using Star Schema is very limiting since you can't write
back to the dimension or change the dimension using MDX
like the Parent-Child dimension.

Can you please explain why you cannot write back to dimension with the star
schema ?

--
==================================================
Mosha Pasumansky - http://www.mosha.com/msolap
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================
"David Boung" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Quote:

I want to build a budgeting cube for write back but when
I have a cube with dimensions other than Star Schema,
consolidated values return errors (#ERR)!

Using Star Schema is very limiting since you can't write
back to the dimension or change the dimension using MDX
like the Parent-Child dimension.

I can get the consolidations to calculate once I
partition the write back data but I can't do that all the
time while users are entering numbers. Users want to see
the consolidated results as they do their data entry.

I have MS OLAP 2000 SP3a.

Any one got any ideas or experience on this?

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

Re: MS OLAP and Writeback

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

Re: MS OLAP and Writeback - 11-06-2003 , 01:58 AM