You can use Anaplan in the same way as other OLAP data sources and connect directly to the source data. Anaplan XL supports reading and writing of data so you can use it for reporting and forecasting.

Module browsing

If your model has many modules, finding the correct one can be tricky. To aid cube browsing, you can create a module with the relevant information.

Review Add metadata to your Anaplan model for more information.

Anaplan XL Web Authentication

An Anaplan tenant administrator must add an OAuth client to Anaplan to enable web users to connect to Anaplan data.

This must be of type "Authorization code grant".

You must add the path to your Anaplan XL install to the redirect URLs. This is of the form [Your AnaplanXLWeb address]/SSOToken.html

  • For example, http://my-server.my-corp.com/AnaplanXLWeb/SSOToken.html
  • Alternately, you can add https://www.xlcubed.com/SSOToken.html and use that if you define the URL in the next step.

Once done, you must add the client ID and secret from the OAuth app to AnaplanXLWeb. Add the keys below to the web.config:

  • AnaplanClientID - the client ID
  • AnaplanClientSecret - the client secret
  • AnaplanClientRedirectUrl - optional - the alternative SSOToken url