Oracle Supply Chain Planning and Business Intelligence Products - A blog dedicated to Oracle's Fusion/On Prem VCP and BI offering.
Monday, October 20, 2008
How to : "Launch Worksheet application"
Friday, October 17, 2008
How To: "Personalize Collaborator Workbench"
You can easily select & manage the panes, change their order of arrangement, select relevant KPI dashboards, member browser content panes, etc. This all can be done by simply using the "Personalize" option available on top-right corner of Collaborator workbench. You will see all the available contents and one can choose based on their usage and need, which contents should be shown on their personal collaborator workbench. One can also move the contents up and down, e.g. you can have "My Tasks" pane on the top and can push the "My Worksheets" pane down.
Personalize "My Worksheets" pane:
It starts with selecting most common and most used worksheets under pane "My Worksheets", by clicking on "Personalize" button on up right corner of pane "My Worksheets". You shall see all the relevant worksheets in and then you can pick ones you want to be shown in the workbench.
Manage "My Tasks" pane:
"My Tasks" pane is like your mail box for Demantra environment, you will get tasks/notifications/alerts/attachments as list items under your content pane "My Tasks". One should ensure completed tasks are removed from the list, so that list of tasks doesn't grow like anything.
Note:
1. Remember that you should not keep lot of Dashboards on your workbench as it can significantly increase the loading time.
2. Treat your collaborator workbench as your office desk, and try to keep only important items on it. Keep it simple and clean to improve your efficiency.
For more details on Collaborator Workbench, read "Demantra Collaborator Workbench User's Guide 7.0.2 " @ http://download.oracle.com/docs/cd/E11885_01/demantra/html/docset.html
Thursday, October 16, 2008
How To: Login into Demantra application
Demantra installer adds a folder with name like "Oracle Demantra Spectrum" under "Start>>Program Files" menu option. (Remember: This startup program option is created only if during installation you have selected the corresponding option)
How To: install Demantra application?
For basic demo environment setup, single tier architecture suits which comprises of having Oracle Database, Demantra application server and Analytical engine, all in one machine.
Demantra installation can be very easily done using the Demantra installer file. But before you start ensure, that you have Oracle DB installed up and running. Also one should keep handy details like Oracle SID, Database system user login, etc. More details on installation can be gathered from following links:
A blog on Oracle Demantra 7.2 installation:
http://applicationsdba.blogspot.com/2008/01/r12-demantra-integration-part-ii.html
Previously published blog on Demantra installation 7.1.1:
http://oracledemantra.blogspot.com/2007/10/installing-demantra-711-on-windows.html
My Oracle Support(Metalink): Oracle Demantra Installation for Release 7.1.1http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=428495.1
My Oracle Support(Metalink): EBS-Demantra Integration Installation Overview and Diagramhttp://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=434991.1
Post installation activities:
1. Set up Environment variable "JAVA_HOME"
2. Launch and verify tomcat(web server) runs fine
3. Launch and test Collaborator workbench application
4. Launch and validate that desktop based application are working fine. (like Business modeler, Demand planner, Engine Administrator etc.)
Wednesday, October 15, 2008
How to: get hold of Demantra documentation ? |
1. Online documentation for Oracle Demantra available at:
"http://download.oracle.com/docs/cd/E11885_01/demantra/html/homeset.html".
2. My Oracle Support (previously known as Metalink):
If you have Metalink login access, then you can search and find all the available documentations released by Oracle.
https://metalink.oracle.com/
3. Oracle Demantra installed folder:
Few basic documents are available when you install Demantra application. These can be found under the installed folder "Oracle Demantra Spectrum".
News: Kyocera gets Demantra
With the solution in place, Kyocera is able to improve accuracy and no longer depends on a manual process for planning and forecasting Also, with Oracle Demantra the company can generate more consistent reports and maintain a better audit trail.
All of these new capabilities also help Kyocera Wireless to better respond to demand as well as generate forecasts and consensus plans without the need of any special expertise. ........................................"
For complete story visit "http://call-center-software.tmcnet.com/topics/call-center-solutions/articles/40585-kyocera-gets-oracle-demantra-from-bearingpoint.htm"
Demantra: "How to" Series
We will be starting a "How to" series, for Demantra which will bring answers to various setup and configuration related queries on Demantra. We will start with basics and then move on to more complex world of Demantra product. In case you have any specific question, then put in comments and we would be glad to include that question in this series.
Tuesday, September 16, 2008
Installing Demantra on SQL server
Demantra application can be installed on Oracle Database as well as on Micrsoft's Database SQL server. Oracle's recent Demantra release 7.2.0.1 is well supported on MS SQL server 2005 database. If you have already are familiar with Demantra installation on Oracle DB, then installing it on MS SQL sever should be pretty easier.
Pre-requisite for Demantra installation on SQL server can be listed as:
1. The client machine where Demantra is being installed should have MS SQL client (same version as server) installed on it.
2. You should extract standard backup file from the installer, say from "F:\Demantra 7.1.1 installer\Disk1\InstData\Resource1.zip >>unzip>>Infra/Database Objects/Microsoft SQL Server/dumps", and put it in the SQL server machine.
3. Keep handy DB server connectivity information and 'sa'(system administrator) login details.
Installing Demantra on SQL Server:
1. Click on "Setup.exe" (Launch anywhere application for installing Demantra) to initiate the installation.
2. Click on option "Install Demantra Spectrum" and then Click on "Next" button at the bottom.
3. In installation tab, Select component of application to be installed. (say, DM) >> Click on Next >>
4. Select Path where you would like to install Demantra.>> Click on Next >>
NOTE: You will have to put backup file in the same path location on Server machine, as mentioned in point 2 of Pre-requisite section above.
5. Select from options available to create Product launch shortcuts. (say, In a new Program Group)>> Click on Next >>
6. Choose Database type as "SQL Server". >> Click on Next >>
7. Provide details for 'sa' login and the SQL server name. >> Click on Next >>
8. Enter SQL DB Schema/User login and Database to be created in case of fresh install. (In case of upgrade you can enter details for existing Demantra database & schema).>> Click on Next >>
9. Select Engine execution type. (Manual or Automated)>> Click on Next >>
10. Wait for Completion of Demantra installation. >> Click on Done>>
Important Note:
- The SQL DB user should have db_creator and bulkadmin permission
- Backup file should be extracted out and stored in correct path, prior to installation
- Password for DB user should respect SQL server security levels(shouldn't be too simple)
- Ensure SQL server connectivity is established and verified
Refer Oracle Metalink for SQL server support related queries.
