Solved

How to perform excel 2013 write back to ssas cube?

Posted on 2015-02-12
4
598 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 24

Accepted Solution

by:
Phillip Burton earned 500 total points
ID: 40605858
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
ID: 40606517
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
ID: 40606837
Also,  do your instructions specifically apply to Cell (measures) Writeback?
0
 
LVL 24

Expert Comment

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

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

623 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