Solved

Writeback into cube using excel services

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

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.
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.
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.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

856 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