epflsti/cubesviewer repository overview

⁠CubesViewer

Available tags and GitHub links: v0.11⁠ v2.0.2⁠ (matching the corresponding releases of CubesViewer)

CubesViewer⁠ is an open-source application suite to exploit and analyze OLAP data cubes⁠ from data in an SQL database.

The CubesViewer suite consists of

• A CubesViewer server (this image),
• A Cubes server⁠ (not covered by this Docker image), which provides the cube's data and schema over a JSON API.

CubesViewer is written and maintained by Jose Juan Montes⁠.

⁠How to use this image

⁠Quick Start

Using the data containers idiom⁠:

docker create --name cubesviewer-data epflsti/cubesviewer:v2.0.2 /bin/true
docker run -d --restart=always --name cubesviewer \
       --volumes-from cubesviewer-data \
       -p 8080:80 \
       -e CUBESVIEWER_BACKEND_URL=http://MY-CUBESVIEWER-HOST:8080/cubesviewer \
       -e CUBESVIEWER_CUBES_URL="http://MY-CUBES-SERVER-HOST:8081" \
       epflsti/cubesviewer:v2.0.2

Be sure to replace the values for CUBESVIEWER_BACKEND_URL and CUBESVIEWER_CUBES_URL with the proper URLs for your deployment scenario. (Note how "backend" actually points to the front-end URL; this is, for better or worse, aligned with the convention in the documentation of CubesViewer itself.)

⁠Populating the Sqlite Database

1. Create a directory containing an initdata.sql with whatever data you want to add into the sqlite database, e.g.

   INSERT INTO "auth_user" ("id", "password",
                            "last_login", "is_superuser",
                            "username", "first_name", "last_name",
                            "email", "is_staff", "is_active", "date_joined")
          VALUES (1, 'pbkdf2_sha256$24000$xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx=',
                  '2016-10-29 12:23:09.288042',1,
                  'dominique','Dominique','Quatravaux',
                  '[email protected]',1,1,'2014-10-25 12:30:12.677939');
   

   Copy
2. docker rm -f cubesviewer
3. Re-run the Docker container like previously, adding your data directory as an additional volume – i.e. add the following somewhere on the command line: ``` -v mydatadir:/initdata