Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
WriteBack in SSAS multidimensional or tabular? Embedding in SharePoint?

Answered WriteBack in SSAS multidimensional or tabular? Embedding in SharePoint?

  • Wednesday, February 13, 2013 11:21 AM
     
     
    Sign In to Vote
    0
    Hello,

    I built up a Data Warehouse in SSIS. I run the OLAP in PowerPivot and also added some measures with DAX in PowerPivot.
    The PowerPivot file is stored on a website built up with SharePoint and is visualised on this website with PowerView.

    How do I set up a WriteBack?
    There is no casual way to enable a WriteBack with PowerPivot. In an earlier project I already used the WriteBack functionality in SSAS multidimensional mode. Is there a simular possibility for WriteBAck in SSAS tabular mode? Shall I use multidimensional or tabular for the WriteBack? Is it possible to embedd and manage SSAS multi or tabular on the SharePoint website?

    I plan to set up an additional Cube for the planning values in SSAS to enable WriteBack. (Yes I could have used just SSAS without PowerPivot. It is a PowerPivot project)


    Best regards!
    Jörg

    • Edited by J.Roca Wednesday, February 13, 2013 11:26 AM
    • Edited by J.Roca Wednesday, February 13, 2013 11:27 AM
    •  
     

All Replies

  • Wednesday, February 13, 2013 12:34 PM
     
     
    Sign In to Vote
    0

    Ok, I just read that Tabular does not support WriteBack yet. So I will use SSAS Multidimensional.

    Is it possible to embedd a SSAS multidimensional Cube or the WriteBack Excel file to a SharePoint website?

     
  • Tuesday, February 19, 2013 6:56 AM
    Moderator
     
     Answered
    Sign In to Vote
    0

    Hi Jorg,

    Writeback is only supported for multidimensional databases, the Excel Calculation Servives (ECS) in SharePoint does not support the write back functionality. Thanks for your understanding.

    Furthermore, I would recommend you refer to the following article:
    Enabling and Securing Data Entry with Analysis Services Writeback: http://msdn.microsoft.com/en-us/library/gg567303.aspx

    Regards,

    Elvis Long
    TechNet Community Support

    • Marked As Answer by J.Roca Wednesday, February 20, 2013 7:35 PM
    •  
     
  • Wednesday, February 20, 2013 2:08 PM
     
     
    Sign In to Vote
    0

    Hi Elvis,

    thank you for your answer!

    Regards

    Jörg


    • Edited by J.Roca Wednesday, February 20, 2013 7:35 PM
    •