Cube

Overview #

The Cube package helps to process your data into cross-tab table. For example, we have this data.

CountryProductSale
U.SiPhone48,000
CanadaSamsung36,000
U.SSamsung44,000
CanadaiPhone12,000

The Cube process can turn above table data into this summarized table:

CountryiPhoneSamsungTotal
U.S48,00044,00092,000
Canada12,00036,00048,000

The summarized data can then be used to draw charts and graphs.

Installation #

By downloading .zip file #

  1. Download zip file from My Licenses
  2. Unzip
  3. Copy the folder cube into koolreport folder, it will look like below:
koolreport
├── core
├── cube

By composer #

If you have purchased the package then you can follow these steps to install

  1. Login to koolreport.com
  2. Go to My Licenses
  3. Click Get Token For Composer button
  4. Copy the text and save to file auth.json next to composer.json
  5. Add the repositories to composer.json like below
  6. Run composer update to install package

composer.json

{
    "repositories":[
      {"type":"composer","url":"https://repo.koolreport.com"}
    ],
    "require":{
        "koolreport/cube":"*",
        ...
    }
}

Your auth.json will look like this:

{
    "http-basic": {
        "repo.koolreport.com": {
            "username": "your@email.com",
            "password": "your-secret-token"
        }
    }
}

Note: Please add your auth.json to .gitignore as it contains your secret login information.