Skip to main content

Power BI

New

SQL Server Analysis Services Cubes write-back

Vote (100) Share
Brian Searle's profile image

Brian Searle on 23 Oct 2015 18:28:30

This depends on having the SQL Server Analysis Services Cubes connector implemented. But now work has started on that I wonder if it will include write-back functionality. This would be ideal for financial planning and budgeting solutions in PowerBI.

Comments (7)
Brian Searle's profile image Profile Picture

a8c9bc29 bae1-426e-890c-dd7c5accc249 on 05 Jul 2020 23:31:40

RE: SQL Server Analysis Services Cubes write-back

This is also mentioned here: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/12903954-support-for-ssas-writeback-functionality

Brian Searle's profile image Profile Picture

ffc1696f 0fca-4a2b-81e3-b66a12c9fa71 on 05 Jul 2020 23:06:40

RE: SQL Server Analysis Services Cubes write-back

I highly support this idea. It already has been posted a few times.
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/20395300-write-back

Brian Searle's profile image Profile Picture

0fdfef82 c7e6-4808-96c6-5bdc4b987e56 on 05 Jul 2020 22:37:39

RE: SQL Server Analysis Services Cubes write-back

'@sebastian there are two flavors of write-back dimension write-back (create new members), this feature is deprecated, but the other flavor cell-writeback to SSAS measure groups is still a much needed capability in financial or sales related planning budgeting scenarios

Brian Searle's profile image Profile Picture

3e03fbd0 2669-4baa-a6cd-809fc16ae2d9 on 05 Jul 2020 22:34:47

RE: SQL Server Analysis Services Cubes write-back

in the major sql server release after sql server 2016 it´s planned not to continue e.g. with the write-back functionality of dimension values (announced to be deprecated), which will completely disable the possibility of having manually set comments by the data. how this integrates with the need of having write back capabilities in the reporting layer as requested here?

Brian Searle's profile image Profile Picture

5f5f397f 2098-4aa8-a91c-83da7522b3ca on 05 Jul 2020 22:32:28

RE: SQL Server Analysis Services Cubes write-back

I totally agree - customers doing financial planning and budgeting ask for write-back options.

Brian Searle's profile image Profile Picture

44b13156 de1d-435e-a622-45bedb1615a3 on 05 Jul 2020 22:27:42

RE: SQL Server Analysis Services Cubes write-back

Any update on this? Would be nice if there is a way that data can be written back on a sharepoint list or excel file.

Brian Searle's profile image Profile Picture

71d4636d e348-4dc7-ba37-e33b80b766b9 on 05 Jul 2020 22:17:15

RE: SQL Server Analysis Services Cubes write-back

Any updates or feedback? Thanks!