Sign Up for Training |
Jet Express Support |
Jet Reports Company Site
Jet Reports Financials
Jet Professional
Jet Enterprise
Downloads
Community
Submit a Request
Give Feedback

How To: Incrementally Load Cubes


Expert



This KB will outline how to setup incremental loading for the cubes.

  1. First you will need to create a partition template. To do this, right-click on the project name at the top of the project tree. Hover over Advanced, then select Add Partition Template. 

  2. Name the partion. Keep Date - System field selected. Next select what the table is going to be partitioned into. You should take into account the amount of time it will take to create these when you execute the cube. The bigger the date range the more parts will need to be created. If you want to partition by something other than date, select Other - Manual setup.

    The Use NULL value Conversion option is used when the date field contains NULL values. It will then insert whatever you input into the box below the option.

    When you're finished click OK.

  3. In the Data Warehouse, right-click on the fact table(s) that the cube you want to incrementally load is using and select Table Settings.

  4. Go to the Performance tab. Check the Enable physical valid table checkbox. In the Table partitioning section select the template you just created. Select the field date field you want to base the partitions on. It could be any date field. If you choose DW_TimeStamp it will create the partitions on new data, though this only works on incremental load tables. Finally select the Time table that will be used. If you do not have a valid Time table in the Data Warehouse you will need to create one.

    Note: If you do create a new Time table, you will need to make it match the one you have setup in the Staging database.



    If you need to create a new Time table select Add new. An add Date table window will open. Name the Date table differently than Date. In this example we called it Date Partition. Make sure all the settings match those in the Date table in the Staging database. Then click OK.

  5. After everything has been setup, click Apply and then OK. The table name should now be red in color. Right-click on it and Deploy and Execute to commit the changes.

  6. Once that completes, go to the Cubes tab and right-click on the cube you want to incrementally load and Edit the cube. Check the Incremental Load box. Make sure you have setup partitioning on all of the fact tables feeding your cube. You can see a list of them in the Fact Tables section of this window. Click OK when finished.

  7. Deploy and Execute the entire OLAP server.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments