[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 831
  • 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

Featured Post

[Webinar] Improve your customer journey

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.

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