SSAS Store Forecasting data in the cube

SQLSearcher used Ask the Experts™
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?


Watch Question

Do more with

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

You could use native SSAS to browse the cubes as described here:

If you want some HTML client to view SSAS data you could use something like Cognos or Tableau

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