SSAS Store Forecasting data in the cube
Hello Experts Exchange
I am developing a Finance cube, I'm trying to mimic the same functionality as SAP BPC.
In Excel the users look at the data in the SAP BPC cube and can view and update the forecasting data.
How do I do this in a SSAS? Is there any document that explain how to do it?
Regards
SQLSearcher
I am developing a Finance cube, I'm trying to mimic the same functionality as SAP BPC.
In Excel the users look at the data in the SAP BPC cube and can view and update the forecasting data.
How do I do this in a SSAS? Is there any document that explain how to do it?
Regards
SQLSearcher
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
you can fine detailed information about how to access SSAS using Excel at links below if this is what you mean by "How do I do this in a SSAS"
https://www.mssqltips.com/sqlservertip/2828/using-excel-to-interact-with-a-ssas-cube/
You could use native SSAS to browse the cubes as described here:
https://msdn.microsoft.com/en-us/library/cc280644(v=sql.120).aspx
If you want some HTML client to view SSAS data you could use something like Cognos or Tableau
http://www-01.ibm.com/support/docview.wss
https://www.tableau.com/embedded-analytics
https://www.mssqltips.com/sqlservertip/2828/using-excel-to-interact-with-a-ssas-cube/
You could use native SSAS to browse the cubes as described here:
https://msdn.microsoft.com/en-us/library/cc280644(v=sql.120).aspx
If you want some HTML client to view SSAS data you could use something like Cognos or Tableau
http://www-01.ibm.com/support/docview.wss
https://www.tableau.com/embedded-analytics
Premium Content
You need an Expert Office subscription to comment.Start Free Trial