Solved

Writeback into cube using excel services

Posted on 2007-12-03
2
1,412 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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
Many companies are looking to get out of the datacenter business and to services like Microsoft Azure to provide Infrastructure as a Service (IaaS) solutions for legacy client server workloads, rather than continuing to make capital investments in h…
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…
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

777 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