Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 4 Next »

After you publish a budget workbook as a stream (dataset) in the underlying database, there might be times when that stream is no longer required, so you want to remove it from the list of available streams. For example, you might have added a new stream as a test case which is now redundant or perhaps you deleted a budget workbook and therefore, the corresponding stream is not relevant to your analysis.

You delete the budget streams from within the Budgets and Forecast module. The method you use to delete a stream depends on whether the budget workbook, or another workbook of the same structure, exists in your Budgets and Forecasts module. For example, suppose you want to delete a stream that has Country and Branch as the dimensions and Local Value as the measure. To delete that stream, you need to be in a budget workbook that has the same structure* as that stream (method 1). If no such workbook exists, you need to create one for the purpose of deleting the stream (method 2).

*You can identify the structure of a stream via the Designer module. If you do not have access to Designer, talk to your Phocas administrator to determine the structure of the budget stream you want to delete.

Method 1

  1. Open the budget workbook, then in the bottom right of the worksheet, click the Publish button.

  2. Click the Budget stream Open button (blue star) to display the list of streams that match the current workbook structure (dimensions and measures). If you do not see the stream you are looking for, you need to use method 2 below.

  3. Click the Delete button of the stream you want to delete.

  4. Close the Publish window. The stream will no longer appear in the Analytics or Financial Statements modules.

Method 2

  1. Create a new (temporary) budget workbook with the same structure (dimensions and measures) as the budget workbook in which the stream was created.

  2. In the bottom right of the worksheet, click the Publish button.

  3. Click the Budget stream Open button (blue star) to display the list of streams that match the current workbook structure. You should see the stream you want to delete.

  4. Click the Delete button of that stream.

  5. Close the Publish window. The stream will no longer appear in the Analytics or Financial Statements modules.

  6. Delete the budget workbook, if it is no longer required.

  • No labels