Cubes creation¶
To add new cube, put your CSV files in a folder (folder name <=> cube name),
make sure that they follow OLAPY CUBES RULES,
and move that folder under olapy-data/cubes
,
thus, the path to your cube will be:
~/olapy-data/cubes/{YOUR_CUBE}/{YOU_CSV_FILES}
for Mac/Linux,C:\\User\\{USER_NAME}\\olapy-data\\{YOUR_CUBE}\\{YOU_CSV_FILES}
for Windows.
OLAPY CUBES RULES¶
NOTE : THE SAME THING IF YOU WANT TO WORK WITH DATABASES
Here are the rules to apply to your tables so that can works perfectly with olapy:
- Make sure that your tables follow the star schema
- The fact table should be named ‘Facts’
- Each table id columns, must be the same in facts table, example ( product_id column from product table must be product_id in Facts table,
- Avoid ‘id’ for id columns name, you should use something_id for example
- The columns name must be in a good order (hierarchy) (example : Continent -> Country -> City…)
take a look to the default cubes structure (sales and foodmart).
Here are two examples of table structures that follows olapy rules: