| Tip |
|---|
To receive an email alert if a build fails, go to your personal user settings and select Email notifications > Build failures. |
Initiate a build
You can build a database from two locations in Phocas.
Initiate a build from the Design screen
In Designer, click the Build tab and click Build. A progress bar displays the status of the build and it turns green when the build is complete. The Logs section of the page displays the details of the build.
This method also gives you the option to cancel or schedule a build (see sections below).
You are automatically given access to the newly created database. Click Open to exit Designer and view your database in Phocas.
Initiate a build from the Administration screen
This method also allows you to build databases that are 'locked' by a solution, in other words, databases that cannot be opened in Designer.
Click Administration > Databases, select one or more databases and click Build.
Schedule a build
If you do not want a build to occur immediately, you can : in Designer and on the Databases page. The Databases page is suitable when you need to build locked databases, which you do not have permission to open in Designer.
In both locations, you have the option to build the database now or schedule a build to occur later . You can do this from two locations in Phocas.
Schedule a build from the Design screen
In Designer, the Schedule button is orange when a schedule is set.
Click the Schedule button.
Select the build frequency:
After any of the sources used in the design have been synced
at regular intervals. The following schedule frequency options are available:
Based on Sync:
After sync of any source used in this design.
After sync of all selected sources. This option allows you to select specific sync sources.
Based on a specified interval:
Hourly
Daily (specify timezone and time).
Weekly (specify timezone, day of week and time).
Monthly (specify timezone, first or last day and time).
Change the default the timezone, if required. The timezone defaults to the your current timezone.
Schedule a build from the Administration screen
Click Administration > Databases, select one or more databases and click More > Schedule, then select the build frequency and click Save.
Build a database via Designer
Open the database in Designer and click the Build tab.
Then select the applicable build method:
Build now: Click Build. As shown in the image above, a progress bar displays the status of the build, which turns green when the build is complete, and the Logs section underneath displays the details of the build. Click Open to exit Designer and view your database in Phocas.
Schedule a build: Click Schedule, select the build frequency and configure the settings as required, then click Save. The Schedule button turns orange to indicate a schedule has been set.
Build a database via the Databases page
In the Phocas menu, click Administration > Databases, select the database(s) you want to build, then select the applicable build method:
Build now: Click Build. The Status column displays the status of the build, which says Available (in green) when the build is complete.
Schedule a build: Click More > Schedule, select the build frequency and configure the settings as required, then click Save. The Schedule column displays the schedule frequency.
Sleep (pause) builds
You can sleep database builds during specified hours, such as at night or the weekend. Accessing the database for analysis purposes during sleep times is unaffected - users are able to can analyze the data based on the last available build.
In the image below, despite the Hourly frequency, the database will not build between 8pm and 6am the following day.
Cancel a build
There might be a situation where you need to cancel a build, for example, if you change your mind about the design after the build has started, you realize you made a mistake, or if the build seems to be 'hanging'.
In DesignerOpen the database in Designer, then on the Build tab, click the Cancel button. You get a message advising you that the build is being cancelledcanceled. It might take a while to complete the cancel cancellation process. When the build is canceled, the status bar turn reds turns red and displays the progress stage the build was at when it was cancelledcanceled.
Set an alert on build failure
To receive an email alert if a build fails, go to your personal settings and select Build failures under Email notifications.
Troubleshooting: Validation errors during build
Design errors
If there are errors in your database design, a Validation Error window will display after you click Build. You need to correct any errors before the build can be queued. Examples of errors include:
Unmapped dimensions
Duplicate names of streams, dimensions, properties and measures
Property titles containing reserved words: "code", "date".
Expressions in calculated measures containing reserved characters: \, @, !, ?, ~, |
Errors in raw data
If there are errors in your raw data (for example, cells containing unclean data, such as an invalid date format) the database build will exclude the affected data from the build, and list this in the build log as a Warning. The excluded data could be a whole line or just a cell.
Clicking Click the link under Detail to display more information about the error.
On this page
| Table of Contents | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
|
Related pages
Overview of Designer (includes access)Save your database design
| Panel | ||
|---|---|---|
| ||
Next step in the design a database process: |