small-data's Introduction

Small Data Solution

An Example: BI for OpenLMIS

Start the cluster in a docker console with docker-compose installed:

cd openlmis-bi
docker-compose up

Load OpenLMIS sample data in another docker console:

cd openlmis-bi
./init-db.sh

Now an interactive Web-based BI system should be running at http://localhost:8000/cubesviewer/. Login credentials are admin/mysecretpassword.

Once logged in, you can click "Add view from JSON" link on the left side, copy & paste following JSON in the popup dialog:

{
    "cubename": "requisition_line_items",
    "name": "ABC Stock In Hand",
    "mode": "chart",
    "drilldown": ["products:products"],
    "cuts": [{
        "dimension": "products",
        "value": "MMIA,08S01;MMIA,08S01B;MMIA,08S01ZZ"
    },{
        "dimension": "facilities",
        "value": "1;7;10"
    }],
    "datefilters": [],
    "rangefilters": [],
    "xaxis": "facilities",
    "yaxis": "stockinhand_sum",
    "charttype": "bars-vertical",
    "columnHide": {},
    "columnWidths": {},
    "columnSort": {}
}

Hit "OK", then you should see the following chart:

small-data's People

Contributors

Watchers

small-data's Issues

Dynamic IP addresses in configuration files

IP addresses hard-coded in docker-compose.yml and slicer.ini must be replaced with value of $SD_CUBES_PORT_5000_TCP_ADDR and $SD_POSTGRES_PORT_5432_TCP_ADDR

Recommend Projects