Link to home
Start Free TrialLog in
Avatar of rhservan
rhservanFlag for United States of America

asked on

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
ASKER CERTIFIED SOLUTION
Avatar of Phillip Burton
Phillip Burton

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of rhservan

ASKER

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?
Also,  do your instructions specifically apply to Cell (measures) Writeback?
Avatar of Phillip Burton
Phillip Burton

You need to enable Enable Read/Write permission - see this Microsoft technical article on the subject