If you already have solution databases from earlier versions of Profitbase Studio (e.g.5.2), you will need to upgrade the solution and data warehouse databases.
Profitbase Studio 6x is a major update from 5x versions. This means that some functionality is discontinued, and that the resulting data warehouse tables and views are changed. After an upgrade, you will need to process dimensions and modules.
Upgrades can be done from PS5.2. For PS5.0 or PS5.1 versions, it is recommended that these are upgraded to PS5.2 first to ensure correct upgrade.
If you upgrade between 6.x versions, you may also need to update databases (solution and server). This is usually smaller updates that do not affect results in the data warehouse database.
Check against the feature/what's new list for alternatives to functionality that are no longer supported.
Following features are no longer supported:
Profitbase Studio 6 allows for new naming of tables and views in the data warehouse database (described here). A normal solution upgrade will keep naming scheme from Profitbase Studio 5. To utilize the new naming scheme, and whenever you want to do a total workover to rebuild your solution, you can do the following:
Warning: The sequence above is a much bigger effort than just running the normal solution Upgrade.
To start an upgrade, log on and select either [Upgrade Solution Database] from the Navigators Start section, or from the main menu select Tools | Database Tasks | Upgrade Solution Database.
From the dialog, select/check the database, and click on [Upgrade Database(s)]. You can expand the log by clicking on the label [View Log Details].
Click on [Close] when upgrade is completed.
When you open this solution in Profitbase Studio the first time after an upgrade from 5.2x versions, the following dialog will show:
You can select from a list of options, on what you want to keep/upgrade:
It is recommended that that you keep these options checked.
Click on [Next] to continue to next page from where you do the upgrade.
Select [Start upgrade process] and the solution content and data warehouse will be upgraded.
Check the log:
When the the steps above are completed and the solution is opened, take the time to validate and process.
Some issues has to be fixed manually:
Also check that