• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 881
  • Last Modified:

How to perform excel 2013 write back to ssas cube?

Current environment:
SQL Server 2014 ssas cube
Excel 2013

Desired:
Use excel to write back to cube

Looking for detailed steps
0
rhservan
Asked:
rhservan
  • 2
  • 2
1 Solution
 
Phillip BurtonDirector, Practice Manager and Computing ConsultantCommented:
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
 
rhservanAuthor Commented:
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
 
rhservanAuthor Commented:
Also,  do your instructions specifically apply to Cell (measures) Writeback?
0
 
Phillip BurtonDirector, Practice Manager and Computing ConsultantCommented:
You need to enable Enable Read/Write permission - see this Microsoft technical article on the subject
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now