Solved

How to perform excel 2013 write back to ssas cube?

Posted on 2015-02-12
4
414 Views
Last Modified: 2016-02-18
Current environment:
SQL Server 2014 ssas cube
Excel 2013

Desired:
Use excel to write back to cube

Looking for detailed steps
0
Comment
Question by:rhservan
  • 2
  • 2
4 Comments
 
LVL 24

Accepted Solution

by:
Phillip Burton earned 500 total points
Comment Utility
You need to go to What-If Analysis - Publish Changes to write it back.
 
If you want detailed steps, then have a look at this website.
 
Here's a video about it.
0
 

Author Comment

by:rhservan
Comment Utility
When I go to publish the result is it times out and does not perform the writeback.
What user security settings do I need to make this work?
0
 

Author Comment

by:rhservan
Comment Utility
Also,  do your instructions specifically apply to Cell (measures) Writeback?
0
 
LVL 24

Expert Comment

by:Phillip Burton
Comment Utility
You need to enable Enable Read/Write permission - see this Microsoft technical article on the subject
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.

772 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

11 Experts available now in Live!

Get 1:1 Help Now