Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Writing to OLAP databases as well as reading from

Writing to OLAP databases as well as reading from

Writing to OLAP databases as well as reading from

I've been doing a bit of background reading and was suprised to see that some OLAP products allow you to write to the database as well as read from.  Is this purely for setting up summary information?  I have a data warehouse background where, certainly in terms of the reporting front end the database is read only.


If it's Data Warehousing or related then I want to know - but post it to the forum!

RE: Writing to OLAP databases as well as reading from

You might include a fact table which has forecast figures. A manager may then want to change these on-screen and update the OLAP cube.

Alternatively, they may want to change some data temporarily for a 'what-if' scenario or because they know that a particular figure is incorrect (or to cook the books!).

my home

RE: Writing to OLAP databases as well as reading from

Write back is usually used in applications that involve "what if" analysis. I have written an number of budgeting applications using Essbase one of the OLAP tools. As long as all the possible data points have been created ahead of time write back works nicely. It also allows imput of data by users. Excel is often the source for this data. MS OLAP requires a ROLAP partition to do this. This means you need Enterprise SQL server. If you are going to look at MS OLAP look at the beta SQL 2000 version it has a bunch of nice fixes. See the OLAPReport.com for more information.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close