This chapter covers the following topics:
By using Oracle Demantra Anywhere, you can access worksheets remotely and perform many of the same tasks described earlier in this manual.
Note: Oracle Demantra Anywhere does not enable you to work offline. That is, you have access to the data only while you are actually logged on. For information on taking a worksheet offline, see Working Offline.
In contrast to the other Oracle Demantra products, Oracle Demantra Anywhere is a true thin Web client and does not require an applet. You can use it to access Oracle Demantra functionality from remote machines, including handheld devices.
On the other hand, Oracle Demantra Anywhere provides less functionality than the other products.These differences are listed below.
Oracle Demantra Anywhere treats data in the same way as other Oracle Demantra products:
Information in Oracle Demantra is secured, and different users have permission to view different data. For details, see the Oracle Demantra Implementation Guide.
The changes you make are not always visible immediately.
The same tips for session management apply to Oracle Demantra Anywhere.
Your session expires if you do not refresh the page periodically. Be sure to refresh the page so that you do not lose data. To do so, rerun the worksheet. If you just mark check boxes or make selections, those actions do not reset the expiration counter.
If you try to refresh the page after your session has expired, an error message informs you that the session has expired. Any work that was done since the last refresh will be lost. An automatic logoff is performed and a page opens with a link to return you to the login page.
Depending on how your system was configured, new data might be available throughout the day. The data is not automatically loaded into your worksheet because that could disrupt your work. To get the latest data, rerun the worksheet.
The following table summarizes the features in Oracle Demantra Anywhere that relate to worksheets and content panes.
The other features in Oracle Demantra Anywhere behave the same as in the Demantra Local Application:
Menus
Personalize link (note that your choices here affect both your view of both the Demantra Local Application and Oracle Demantra Anywhere)
To log onto Oracle Demantra Anywhere:
Open a web browser.
Enter the URL supplied by your system administrator. This URL probably has the following format:
http://server name/virtual directory/portal/anywhereLogin.jsp For example: http://frodo/demantra/portal/anywhereLogin.jsp
In the login dialog box, enter your user name and password.
Click Login.
See also:
A Brief Tour of the Demantra Local Application
Introduction to Oracle Demantra Anywhere
Click the name of the worksheet.
To run or rerun a worksheet:
Depending on how Oracle Demantra was configured, it may or may not automatically run the worksheet that you open.
Click the Rerun icon on the toolbar to rerun the worksheet.
See also Opening a Worksheet in the Demantra Local Application.
Within Oracle Demantra Anywhere, you can access any public worksheet created in Oracle Demantra, but the worksheets have a simplified appearance.
To view or edit worksheet properties:
Click the Actions button and then click Worksheet Properties.
To save a worksheet:
To save a worksheet with the existing name, click the Actions button and then click Save.
To save a worksheet with a different name, click the Actions button and then click Save As.
To delete the current worksheet:
Click the Actions button and then click Delete Worksheet.
To send the worksheet as a task:
Click the Actions button and then click Send as Task.
The Send Task to User dialog box appears.
In the To field, enter a valid Demantra user or group name. Alternately, you may double click the To field and then choose from a list of defined users and groups, and then click Choose.
Type your message in the Message field.
To send an e-mail notification to the recipient of the task, select the Send email list check box.
To ensure that this task is completed by a specific time, click Escalate and then provide the following information:
Due date: Date and time by which this task must be completed
Alert time: Date and time at which an alert will be displayed
To: Additional e-mail addresses
Click Ok.
To select a worksheet display:
Click the Table and Graph buttons to toggle the worksheet display.
To select a different combination to display:
Select level members from the level dropdown lists (for example, Brand or Ship to).
To save data:
Click the Save Data button.
To reset manual changes since the last time you saved data:
Click the Actions button and then click Reset Manual Changes.
To rerun the worksheet:
Click the Rerun button.
To print the currently displayed data:
Click Actions button and then click Print The Current View.
To work with levels:
To add a level to the worksheet, click the Add Level button.
To move a level within the worksheet, select the level and then click one of the four arrow buttons.
To hide a level, select it and then click the Hide a Level button.
To view all hidden levels, click the Unhide Levels button.
To work with series:
To add a series to the worksheet, click the Add Series button.
To hide a series, select it and then click the Hide Series button.
To view all hidden series, first click the Unhide Series button to display a list of the hidden Series and then you select one Series in the list. The selected Series is then displayed in the table.
To move a series within the worksheet, either:
Select the series and then click one of the four arrow buttons.
Right-click on a Series heading and select Cut. Then right-click on another Series and select Paste. The series the you cut will be move to after the series you did the paste on.
To run a simulation:
Click the Simulation button, and then click either Entire Worksheet Simulation or Selected Combination Simulation
To approve a simulation:
Click the Simulation button and then click Accept Simulation
To reject a simulation:
Click the Simulation button and then click Reject Simulation.
To filter a worksheet:
Click the Filters button.
The Worksheet Filters dialog box appears.
Find the aggregation level at which you want to filter data and move it from the Available Filter Levels list into the Selected Filter Levels list.
In the Available Members list, find a member that you want to include in the content pane and move it into the Selected Members list.
Continue to move members from the Available Members list into the Selected Members list, until the latter list includes all the members you want.
Click Ok to filter the worksheet.
To work with worksheet dates:
Click the Date Range button.
To change the date aggregation period:
Specify the time resolution of the worksheet results. The data in the worksheet is aggregated to this time resolution. That is, this option specifies the period of time that each data point in the line graph represents.
Specify the time period to which the worksheet applies:
Specify as Fixed Dates: if you always want the worksheet to show a specific time range, regardless of the current date.
Specify as Relative to Today: if you always want the worksheet to show a time range relative to today.
Specify Relative to Last Sales Date: if you always want the worksheet to show a time range relative to the last sales date in the loaded data.
In the From Date and To Date boxes, enter values depending on the time filter you have chosen.
To change the unit of measure:
Click the Unit button.
The Unit Selection dialog box appears.
From the Unit Type drop-down list box, select the new unit of measure.
Click OK.
To view a note:
Click the note icon within the cell.
The Note page appears, displaying a list of all the notes. This list indicates the date of each note, as well as who entered it. The Combination field shows the item-location combinations to which the currently selected note belongs.
To see the note details, click Description.
To close the Note page, click the X in the upper right corner.