Solved

Writeback into cube using excel services

Posted on 2007-12-03
2
1,403 Views
Last Modified: 2013-11-16
We have to integrate SQL Cubes with Excel web services(in sharepoint). We are able to read the data from cubes into an Excel uploaded on Sharepoint.However we are stuck on trying to write back to the same.In excel 2000, VB macros could be used but what about excel web Services
0
Comment
Question by:knaren_1975
2 Comments
 
LVL 12

Accepted Solution

by:
RWrigley earned 500 total points
ID: 20425064
Write back into cube?  I don't understand.  Cubes are typically read-only.  You'd could write into the relational database that cube is created from, and design the cube as HOLAP or enable "Dynamic Caching" have the cube automatically rebuilt though...
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

This article explains all about SQL Server Piecemeal Restore with examples in step by step manner.
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now