Installation Guide

This guide covers basic setup of MDX2JSON project and describes installation troubleshooting process. If something is unclear, please file an issue.

Variables

localhost:57772 - server:webport mdx2json - Namespace, where we would install MDX2JSON project
/mdx2json - Web application name web - пuser, with access to mdx2json
_SYSTEM - administrator with %All role
samples - target namespace with dashboards and pivots

Basic setup

Comprehensive description can be found here. Follow Installation or Installation without fs access to server or Offline Installation instructions. Note additional installation parameters.

Note:

• Installation must be done by user with %All role
• Installation into new, unexisting namespase (would be created during install automatically) is strongly preferable
• Optional parameters User and Password would create user with all necessary roles, please use

On install fail copy error output and run install again. If the problem persists, create an issue and do an install manually, use following steps.

Initial checks

Open http://localhost:57772/mdx2json/Test?Debug
Sample output

Errors:

• 401 - if your browser does not provide authentication box, use REST client and add Authorization header. Alternatively set only Unauthenticated access method in /mdx2json web app (and add required roles)
• 403 - user does not have permissions to access mdx2json namespace
• 404 - check that webapp exists and url is correct

Permissions check

Open http://localhost:57772/mdx2json/Test?Debug
Check the following json properties

• Mappings->Mapped contains namespace list, where mdx2json package is availible, check that samples namespace is there, add mapping manually, if not
• Roles - check that user can access namespace with dashboards (%DB_<DBName>), this can also be checked in User Portal
• User: there must be expected web user

Permissions check in target namespace

Open http://localhost:57772/mdx2json/Test?Debug&Namespase=samples

• 403 - user does not have permissions to access samples namespace.

Check cube access

User web must have access to:

• Cube fact table
• Listing tables

If you followed all the steps, MDX2JSON must be in working order.