Recently added item(s)
You have no items in your shopping cart.
This section provides simple step by step instructions on how to setup the infrastructure without going into the details. This might be useful for the initial setup during the evaluation for the users not yet familiar with all concepts.
Magento 1 extension files can be downloaded from the www.bimproject.net after purchasing the license. Read “Installation” section of this documentation to get more information on how to install the extension on Magento 1.
Magento 2 extensions are distributed using private composer repository. Credentials required to access the repository are available on the website details page on www.bimproject.net.
To install the extension on Magento 2 store, perform the following steps (after purchasing of the extension license):
[{ "type": "composer", "url": "http://www.bimproject.net/en/bim_repo/composer/index" }]
{ "http-basic": { "www.bimproject.net": { "username": "<user from website settings page>", "password": "<password from website settings page>" } } }
composer require bim/pbi-sales-cube-metapackage-magento2:2.2.4.1
bin/magento setup:upgrade
bin/magento setup:di:compile
Read “Installation” section of this documentation to get more detailed information on how to install the extension on Magento Platform.
# File app/etc/env.php in Magento 2
...
'db' => [
'connection' => [
'default' => [
...
],
'bim_dwh' => [
...
],
'bim_data_export' => [
...
]
]
],
'resource' => [
'default_setup' => [
'connection' => 'default'
],
'bim_dwh' => [
'connection' => 'bim_dwh'
],
'bim_data_export' => [
'connection' => 'bim_data_export'
]
],
...
# File app/etc/local.xml in Magento 1
...
<resources>
<default_setup>
<connection>
<host><![CDATA[localhost]]></host>
...
</connection>
</default_setup>
<bim_dwh>
<connection>
<host><![CDATA[localhost]]></host>
...
</connection>
</bim_dwh>
<bim_data_export>
<connection>
<host><![CDATA[localhost]]></host>
...
</connection>
</bim_data_export>
</resources>
...
4. Run by crontab the following command every minute:
# For Magento 2 bin/magento bim:etl:scheduler
# For Magento 1 shell/bim_etl.php scheduler
Do not Load the Dataset yet if the store has lot of data! Initial load might take significant time (up to 1 day).
Publish the created Sales Cube dataset by clicking on “Publish” button on dataset properties page.
Please, not that this will crease dataset in Power BI, but will not populate it with data yet.
For the stores with log of data, do the estimation of the amount of data in the dataset to make sure, it does not go over the limitations of Power BI:
Trigger the start of data loading. Depending on the amount of data, it may take different time depending on the amount of data and the Power BI account limitations.
To start loading of the data:
To load the dataset manually click on “Load” button on dataset properties page inside Magento Platform (only recommended for the cases when dataset does not have lot of data).
Once the initial load is done, user can configure the desired interval for data actualization by configuring Live or Regular schedules and assigning the dataset to this schedule. Additionally it is recommended to configure the clean-up schedule. All created datasets will update full set of data by the clean-up schedule.
Step 10 and 11 are only for Full version of the Sales Cube package that includes the templates and the embedding functionality.
After the data will be delivered to PBI (or will start to be delivered), user can upload reports and configure embedding functionality.