SSAS Store Forecasting data in the cube

SQLSearcher
SQLSearcher used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Database Analyst
Commented:
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

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial