8 Configuring Cognos Cubes

This chapter provides information about the following:

• Setting Up Cognos 8 Cubes

• Configuring Cognos Cubes

• Configuring IIS and Drill-Through on the Cube Server

• Setting Up Batch Generation for Cubes

• Additional Cubes Configuration

8.1 Setting Up Cognos 8 Cubes

This section is intended for the use of Cognos 8 users. If you are using Cognos Series 7.4 software, this section is not required.

Use this procedure to schedule the process that generates Cubes-on-the-fly.

1. In the Cognos 8 Server, go to <Argus Insight Directory>\ArgusInsight\Cognos\Cubes\PublishDemandCube folder.

2. In the DemandPublish.bat and DemandSource.bat files, set the following:

   1. JAVA_Home to the Java_Home path on the Cognos 8 server.

   2. JAR_Home to your <Argus Insight Directory>\ArgusInsight\Cognos\Cubes\PublishDemandCube\lib

   
   
   

3. Save both files and exit.

4. Go to <Argus Insight Directory>\ArgusInsight\Cognos\Cubes\BatchGeneration-Cubes folder.

5. Open the GenerateCubes.cfg file.

   
   

6. Set the following parameters in the GenerateCubes.cfg file:

   Parameter	Description
   ArgusInsightPath	This is the Argus Insight installation path; include the ArgusInsight folder in the string: <Argus Insight Installation path>\ArgusInsight
   CognosPath	This is the location of the Cognos 8 installation bin folder: <Cognos 8 installation path>\c8\bin
   ServerName	This is the name or IP address of the Cognos 8 server. If the Cognos 8 server is running on a port other than the default port, then the parameter values should be entered in this format: ServerName:PortNumber. For example, Cog8Server:9300
   CubeSaveDir	This is the path of the Argus Insight installation directory. This provides the path for saving the cube output files on their exact location.
   CubeDataSourceDir	This is the path of the Argus Insight installation directory. This provides the path for the datasource files which are used for cube generation.

   
   
   
   

   Note: Although the paths may contains whitespaces, make sure there is no white space between the parameter name, the "=" sign, and the value.

   
   

7. Save and close the configuration file.

8. Go to the <Cognos8 installation path>\c8\configuration folder and open the cogtr.xml file.

   
   

9. Modify this file to set the following parameters:

10. The following table describes the new parameters in this file:

    Parameter	Description
    CubeSaveDirectory	This is the path of the Argus Insight installation directory. This provides the relative path for saving the cube output files on their exact location.
    DataSourceDirectory	This is the path of the Argus Insight installation directory. This provides the relative path for the datasource files which are used for cube generation.
    DataWorkDirectory	Any path on the Cognos 8 server, which will be used to store some temporary files during cube generation.
    LogFileDirectory	Any path on the Cognos 8 server, where all the cube generation log files will be saved.
    ModelSaveDirectory	This is the path of the Argus Insight installation directory. This provides the relative path for saving the cube model files during cube generation.
    ModelWorkDirectory	Any path on the Cognos 8 server, which will be used to store some temporary files during cube generation.

    
    

11. Go to the <Cognos8 installation path>\c8\cs7Gateways\bin folder and open the cs7g.ini file.

    
    

12. Add the following configuration item in the cs7g.ini file:

    [Databases]

    Power Reports=^User ID:^?Password:;LOCAL;OR;ORACLE@apr_app@PRMART/manager@COLSEQ=

    where:

    • APR_APP is the DataMart Application Owner

    • PRMART is the Alias Name for the Argus Insight DataMart

    • Manager is the Password for the APR_APP user.

13. Save the file and exit.

14. Go to Start > Programs > Cognos 8 > Cognos Configuration.

15. When the system opens the Cognos Configuration window appears, click Restart to restart the Cognos 8 service.

    
    

16. If any warnings exist during the Cognos service restart, the following screen may appear. Click Yes to ignore these warning if they appear to be the result of a mail server connection failure.

    
    

17. When the system opens the following dialog box, click Close to exit the Cognos configuration.

    
    

8.1.1 Configuring the PowerPlay Enterprise Server

This section is for the user of Cognos Series 7.4 users. If you are using Cognos Series 8 software, this section is not required. Use the following procedure to configure the PowerPlay Enterprise Server. Follow the installation procedures in the order in which they appear.

8.1.1.1 Configuring Cognos Cubes

1. Select Start> Program > Cognos Series 7 Version 4 > Tools > Configuration Manager.

2. When the system opens the following window, select File>Open Current Configuration.

   
   

3. When the system opens the following window:

   
   

   • Select the Services > Cognos Application Firewall > General control tree item in the left pane.

   • In the right pane, verify that Firewall enabled is set to False

4. Open Configuration Manager and go to Services -> UDA->General:

   
   

   • Set the window view to Advanced to view the properties.

   • Set Memory Size of Sort Buffer = 1024

   • Set the List of Temporary Directories to a system drive with approximately 20 GB of free space.

5. Select Services->PowerPlay Data Services->Cache.

   
   

   • Set Write Cache Size = 65536.

   • Set Read Cache Size = 65536.

   • Set Object Cache Size = 10000.

   • Set Flush Percentage = 1000.

6. Select Cognos PowerPlay->General.

   
   

   • Set Read Cache Size to 65536

7. Add the Fetch Number of Rows value to the <PPES installation directory>\cer5\Bin\Cogdmor.ini file:

8. Fetch Number of Rows=100

9. Add the following text in Cognos.ini, located at <PPES installation directory>:

10. Power Reports=^User ID:^?Password:;LOCAL;OR;ORACLE@%s@PRMART/%s@COLSEQ=

11. Open <PPES installation directory>\cer5\Data\Bin\trnsfrmr.ini> file and set the MultiFileCubeThreshold key to the following value:

    • MultiFileCubeThreshold=10000000

      
      

      Note: If the transfrmr.ini file is not present at the specified location, open the Transformer from Start>Programs>Cognos Series 7 Version 4> Tools.

      
      

12. Set the path for Cubes.

13. Add or edit the values of following entries in trnsfrmr.ini located at following location:

    <PPES installation Directory>\Cer5\Data\Bin\trnsfrmr.ini

    • DataSourceDirectory=<Argus Insight installation Directory>\ArgusInsight\

    • CubeSaveDirectory=<Argus Insight installation Directory>\ArgusInsight\

    • ModelSaveDirectory=<Argus Insight installation Directory>\ArgusInsight\

    • DataWorkDirectory= any Directory which exists on system. Eg.c:\Temp1

    • ModelWorkDirectory= any Directory which exists on system. Eg.c:\Temp1

    • LogFileDirectory=c:\temp\cubes\logs. This directory will contain all the logs for cube generation

14. Select the machine name from the left pane.

15. Select Actions > Validate Selection from the menu bar.

16. When the system opens the following dialog box, click Yes.

    
    

17. When the system opens the following dialog box, click OK.

    
    

18. Select Actions > Apply Selection.

19. When the system opens the following dialog box, click Yes.

    
    

20. When the system opens the following dialog box, click OK.

    
    

21. Select File > Exit.

8.1.1.1.1 Cubes Configuration

Use the following procedure to configure cubes.

1. Select Start > Program > Cognos Series 7 Version 4 > Tools > Access Manager Administration.

2. When the system opens the Access Manager- Administration window

   
   

   • Expand the Directory Servers folder and click Server Name>Default.

   • Enter the User name and Password, if prompted to do so.

3. When the system opens the following window, right click Data Source> Add Database to add a new database.

   
   

4. When the system opens the following dialog box:

   
   

   • Type Power Reports in the Name field.

   • Click the Connection tab.

5. When the system opens the Connection tab:

   
   

   • Select the database type as Oracle.

   • Click Edit

6. When the system opens the following dialog box:

   
   

   • Type PRMART in the Enter SQL * Net Connect String field.

   • Click OK to exit the window.

7. Click OK to exit from the Database Properties window.

8. Go to Data Sources->Power Reports and right-click Signons.

9. Select Add Database Signon from the popup menu.

   
   

10. When the system opens the following dialog box:

    
    

    • Type apr_app in the User ID field.

    • Type the apr_app password in the Password field.

    • Retype the password in the Verify Password field.

    • Click OK to save and exit.

11. Go to the Cubes Server Name> Default.

12. Right click on the default namespace and select Properties.

13. When the system opens the following dialog box, click the Signons tab.

    
    

14. When the system opens the Signons tab, locate the Active Signons section and click the Both option button.

    
    

15. Click Settings to open the Settings tab.

    
    

    • Click Use the following account for anonymous access option button and type Administrator in the associated text box.

    • Click OK

16. Go to Cubes Server Name-> Default->Users:

    
    

17. Right-click Administrator (Anonymous user).

18. Click Properties.

19. When the system opens the following dialog box:

    
    

    • Click the User Signons tab.

    • On the User Signons tab, verify that the following field attributes are enabled, as shown in the following illustration.

    • Click Add.

20. When the system opens the following dialog box:

    
    

    • Type the domain user name in the text box.

    • Verify that the user is part of the Administrator group on the Cognos 8 server.

    • Click OK.

21. When the system opens the following dialog box:

    
    

    • Click the Access tab

    • Click the Power Reports checkbox to select it.

    • Click Set . . . .

22. When the system opens the following dialog box:

    
    

    • Select apr_mart.

    • Click OK to save and exit.

23. Click OK again to close the Administrator (Anonymous user) Properties dialog.

24. Keep the Access Manager window open and go to the Configuration Manager.

    • Restart the services from Configuration Manager.

    • Exit the Configuration Manager window and the Access Manager window.

8.2 Configuring IIS and Drill-Through on the Cube Server

This section is intended for use by Cognos Series 7.4 users. This section is not required if you are using Cognos Series 8 software.

Use the following procedure to configure IIS on the Cube Server.

1. On the Cube Server desktop, go to Start > Settings > Control Panel > Administrative Tools > Internet Services Manager:

2. Expand the control tree item corresponding to the Power Reports Web Server name.

3. Right-click Default Website>New>Virtual Directory. . . .

   
   

4. When the system opens the following dialog box, click Next>.

   
   

5. When the system opens the following dialog box:

   
   

   • Type Cognos in the Alias field.

   • Click Next>.

6. When the system opens the following directory:

   
   

   • Click Browse.

   • Select the following location: <Cognos Installation Path on Cube Server>\cer5\webcontent. Click OK

   • Click Next>.

7. When the system opens the following dialog box:

   
   

   • Click the Read Run scripts (such as ASP), Execute (such as ISAPI applications of CGI), and Browse checkboxes.

   • Click

   • Click Next>.

8. When the system opens the following dialog box, click Finish.

   
   

9. When the system opens the following window, expand the Default Web Site folder in the control tree.

   
   

10. Right-click the Cognos>New>Virtual Directory . . .

    
    

11. When the system starts the Virtual Directory Creation Wizard, click Next>.

    
    

12. When the system opens the following dialog box:

    
    

    • Type cgi-bin in the Alias field.

    • Click Next>.

13. When the system opens the following dialog box:

    
    

    • Click Browse.

    • Select <Cognos Installation Path on Cube Server>\cer5\cgi-bin from the window and click OK.

    • Click Next>.

14. When the system opens the following dialog box:

    
    

    Check the following checkboxes:

    • Read

    • Run scripts (such as ASP)

    • Execute (such as ISAPI applications or CGI)

    • Browse

15. Click Next.

    
    

16. When the system opens the following dialog box, click Finish.

17. The system opens the WWW Configuration dialog box.

18. Close the Internet Information Services window.

    
    

8.2.1 Configuring Cubes

Use the following procedure to configure the Cognos Cubes for Cognos Series Version 7.4.

1. On the Cubes Server desktop, go to Start > Program Files > Cognos Series 7 Version 4> Cognos Server Administration.

2. Click the OLAP Cubes and Reports link.

   
   

3. Select the Cube Server Name from the Server name list box. Click OK.

   
   

4. When the system opens the following dialog box, click Yes.

   
   

5. When the system opens the following dialog box:

   
   

   • Type the Cognos User ID in the User ID field.

   • Type the password in the Password field.

   • Click Log On.

6. When the system opens the following dialog box, check all the checkboxes. Click OK.

   
   

7. When the system opens the PowerPlay Enterprise Server Administration window:

   
   

   • Right-click the Cube Server name in the left pane of the Server Administration window.

   • Select Properties from the popup menu.

8. When the system opens the Server Properties dialog box, click Settings.

   
   

9. The system opens the Settings tab.

   
   

   Set the values for the items on the Settings tab as shown in the following table. Click Apply.

   Setting Name	Value to Enter / Select
   Options
   Resource (/ppwb) location	<Cognos Installation Path>\cer5\webcontent\ppwb
   Imported Reports Folder	Imported Reports Folder
   Temporary files location	<Cognos Installation Path>\cer5\ppservertemp
   Temporary directory clean-up Interval (min)	15
   Security dialog box	Disabled
   Administrator email address	Leave this field blank.
   Selection of preferences	Disabled
   Auditing level	Detail
   Fetch files	0
   Maximum Restrict Client Connections	50
   Restrict Connection Idle Timeout (min)	60
   Table of Contents	Enabled
   Prompt for User Class	Enabled
   Silent User Class Switch	Disabled
   PowerPlay Web Explorer
   Temporary File Deletion Interval(s)	900
   Alerts	Disabled
   PowerPlay Web Viewer
   Temporary File Deletion Interval (days)	30
   Publishing
   Default Portal	Upfront
   Delete related Cognos ReportNet object when deleting local cubes	Enabled

   
   

10. Select the Report Settings tab.

    
    

11. Set the values for the items in the Report Settings tab page as shown in the following table. Click Apply to apply the settings.

    Setting Name	Value to Enter / Select
    Drill Through
    PowerPlay Cubes	Enabled
    Cognos ReportNet/Cognos8	Enabled

    
    

12. Click OK.

13. Select the Cube Server name in the left pane of the Server Administration window.

14. From the menu bar, select Insert > Folder.

15. When the system opens the Folder Properties dialog box , click the General tab.

    
    

    • Enter PowerReports in the Name text box.

    • Specify the following path in the Folder source field:

      <Argus Insight Installation Path>/Cognos/PPESCubes

    • Click the Cube Settings tab.

16. The system opens the Cube Settings tab.

    
    

17. Set the values for the items in the Cube Settings tab, as specified in the following table. Click Apply.

    Setting Name	Value to Enter / Select
    Drill Through
    Save as Power Cube	Enabled
    PowerPlay Cubes	Enabled
    PowerPlay Window Target	<Cube Server Name>:8010
    Cognos ReportNet/Cognos8 Server	http//<Cognos8 Server>/cognos8/cgi-bin/cognos.cgi
    Cognos ReportNet/Cognos8	Enabled
    Cognos ReportNet/Cognos8 Folder	/content/folder[@name='ArgusInsight']/folder[@name='DrillThrough']
    Cognos Report Net Assistance	Disabled

    
    

18. Select Server>Exit from the menu bar to close the Server Administration window.

    
    

19. Copy the ppwbcustom.js file from the following location: \\<Argus Insight Web Server>\<Argus Insight Installation Path>\ASP\include\js to the following location on the Cube Server: <Cognos Installation Path>\cer5\webcontent\ppwb

20. Go to <Argus Insight Directory>\ArgusInsight\Cognos\Cubes\BatchGeneration-Cubes folder.

21. Open the GenerateCubes.cfg file.

    
    

22. Set the following parameters in the GenerateCubes.cfg file:

    Parameter	Description
    PowerReportsPath	This is the Argus Insight installation path; include the ArgusInsight folder in the string: <Argus Insight Installation path>\ArgusInsight
    CognosPath	This is the location of the Cognos 8 installation bin folder: <Cognos Cubes installation path>\cer5\bin
    ServerName	This is the name or IP address of the Cognos Cubes Server. Enter the parameter values in this format: ServerName:PortNumber. For example, CognosCubeServer:8010.

    
    
    
    

    Note: Although the paths may contains whitespaces, make sure there is no white space between the parameter name, the "=" sign, and the value.

    
    

23. Save and close the configuration file.

8.2.2 Setting Up Batch Generation for Cubes

Although the ETL process updates the datamart on a regular basis, you need to separately update each Cube after the incremental ETL process is completed. To do this, set up a batch process to update the Cubes installed as part of the Argus Insight application. The batch process performs the following tasks:

• Updates Cube data

  The system updates Cube data with the latest data from the datamart.

• Copies the updated Cubes in the backup folder

  The system copies the updated Cubes into a backup folder that contains subfolders for each Cube; the backup folder path is as follows:

  <Argus Insight Installation path>\ArgusInsight\cognos\backup\PPESCubes

  For example: C:\Program Files \Oracle\ArgusInsight\Cognos\backup\PPESCubes

• Copies the updated Cubes in the published folder

  The system copies the updated Cubes into the published folder at this location:

  <Argus Insight Installation path>\ArgusInsight\cognos\PPESCubes

  For example: C:\Program Files\Oracle\ArgusInsight\Cognos\PPESCubes

Schedule individual tasks to update each Cube. To improve the performance of the batch process, make sure that individual batch execution processes do not overlap with each other.

8.2.2.1 Setting up Batch Generation through Task Manager:

This section provides information for using Windows Task Manager to schedule batch generation. Use the following procedure to set up batch for each of the five Cubes.

1. On the Cognos8/Cube Server, select Start > Settings > Control Panel.

2. When the system opens the Control Panel window, double-click Scheduled Tasks.

   
   
   
   

   Note: The appearance of Scheduled Tasks in Microsoft Windows 2008 is differently from the Scheduled Tasks in Microsoft Windows 2003.

   
   

3. When the system opens the Scheduled Tasks dialog box, double-click Add Scheduled Task.

   
   

4. When the system opens the Scheduled Task Wizard dialog box, click Next>.

   
   

5. When the system opens the following dialog box, click Browse.

   
   

6. When the system opens the following window:

   
   

   • Navigate to the following location: <Argus Insight Installation Drive>\ProgramFiles\Oracle\ArgusInsight\Cognos\Cubes\PublishDemandCube

   • Select the CubeGenMonitor.exe file.

   • Click Open.

7. When the system opens the following dialog box:

   
   

   • Type the Cube Name in the text box.

   • Locate Perform this task and select the frequency for refreshing the Cube.

   • Click Next.

   
   

   Note: You can assign any name to the task, but we recommend that the name be similar to the name of the Cube you are scheduling. The following:

   
   

   Cube Name	Cube ID
   Medical Analysis	7
   Clinical Trial Analysis	8
   Overdose-Pregnancy-Interaction	9
   Submission Statistics	10
   Administration Statistics	11

   
   

8. When the system opens the following dialog box, select the start time and day. Click Next>.

   
   

9. When the system opens the following dialog box:

   
   

   • Type the name of the user authorized to run this task in the Enter the user name field.

   • Type the user password in the Enter the password field.

   • For verification, type the password in the Confirm password field.

   • Click Next>.

10. When the system opens the following dialog box check the Open advance properties for this task when I click Finish check box. Click Finish.

    
    

11. Double-click the Medical Analysis tab and open from the Scheduled Tasks. When the system opens the following dialog box, enter the run-time parameter for this task in the following format:

    
    

    <Argus Insight installation path> \ArgusInsight\Cognos\Cubes\PublishDemandCube\CubeGenMonitor.exe <Cube ID> <

    where:

    CubeID identifies the Cube for which you are scheduling the batch generation.

12. The following table lists the Cube ID for each cube and provides examples of the run-time parameter to enter.

    Cube Name	CubeID	Example Run-Time Parameter
    Medical Analysis	7	"C:\Program Files\Oracle\ArgusInsight\Cognos\Cubes\PublishDemandCube\CubeGenMonitor.exe" 7
    Clinical Trial Analysis	8	"C:\Program Files\Oracle\ArgusInsight\Cognos\Cubes\PublishDemandCube\CubeGenMonitor.exe" 8
    Overdose-Pregnancy-Interaction	9	"C:\Program Files\Oracle\ArgusInsight\Cognos\Cubes\PublishDemandCube\CubeGenMonitor.exe" 9
    Submission Statistics	10	"C:\Program Files\Oracle\ArgusInsight\Cognos\Cubes\PublishDemandCube\CubeGenMonitor.exe" 10
    Administration Statistics	11	"C:\Program Files\Oracle\ArgusInsight\Cognos\Cubes\PublishDemandCube\CubeGenMonitor.exe" 11

    
    

13. When the system opens the following dialog box:

    
    

    • Type the password for the Cognos 8 Server admin user in the Password field.

    • For verification, type the password in the Confirm Password field.

    • Click OK.

14. When the system displays the following dialog:

    
    

    • Click the Schedule tab.

    • Set the appropriate schedule options.

    • Click the Settings tab.

15. When the system opens the Settings tab, set the options as shown in the following illustration. Click OK.

    
    

16. The system creates the new scheduled task CubeGenMoitor (or Cube Name you have specified).

17. Repeat Steps 1 through 15 to schedule batch generation for the remaining cubes.

8.2.2.2 Setting up Batch Generation for Demand Cubes

Use the following procedure to set up batch generation for Demand Cubes.

1. Log on to the Cube Server as an Admin user.

2. On the Cube Server, select Start > Settings > Control Panel. Double-click Scheduled Tasks.

   
   

3. When the system opens the following dialog box, double-click Add Scheduled Task.

   
   

4. When the system opens the following dialog box, click Next>.

   
   

5. When the system opens the following dialog box, click Browse.

   
   

6. Navigate to the following location: <Argus Insight Installation Path>\ArgusInsight\Cognos\Cubes\PublishDemandCube.

7. Select the CubeGenMonitor.exe file. Click Open.

   
   

8. When the system opens the following dialog box, select Daily. Click Next.

   
   

9. When the system opens the following dialog box, set the start time, frequency, and start date for the process, as appropriate. Click Next>.

   
   

10. When the system opens the following dialog box:

    
    

    • Type the User ID in the Enter the user name field.

    • Type the user password in the Enter the password field.

    • For verification, type the password in the Confirm password field.

    • Click Next>.

11. When the system opens the following dialog box, click Open advanced properties for this task when I click Finsh checkbox. Click Finish.

    
    

12. Double-click the created task from the Scheduled Tasks. Select the Schedule tab. Click Advanced.

    
    

13. When the system opens the following dialog box:

    
    

    • Check the Repeat Task checkbox.

    • Set how often the task will be executed.

    • Click the Duration option button and enter the duration as 24 hours.

    • Click OK.

14. Select the Settings tab. Do the following:

    
    

    • Verify that the Stop the task if it runs for checkbox is checked.

    • Enter the number of hours and minutes.

    
    

    Note: This value can increase depending upon the size of the case series used to generate a cube.

    
    

15. Click OK.

8.3 Additional Cubes Configuration

This topic has instructions on configuring the cubes.

8.3.1 Configuring Cognos 8 Cubes in Non-Shared environment

1. Configure the Coggtr.xml file as shown below.

   
   

   The following table describes the new parameters in this file:

   Parameter	Description
   CubeSaveDirectory	This is the path on the Cognos 8 server for storing the output file generated as result of cube generation process. This is the path of the Argus Insight installation directory in a non-shared environment. It provides the relative path for saving the cube output files on their exact location.
   DataSourceDirectory	This is the path of the Argus Insight installation directory in a non-shared environment. This provides the relative path for the datasource files which are used for cube generation.
   DataWorkDirectory	Any path on the Cognos 8 server, which will be used to store some temporary files during cube generation.
   LogFileDirectory	Any path on the Cognos 8 server, where all the cube generation log files will be saved.
   ModelSaveDirectory	This is the path of the Argus Insight installation directory. This provides the relative path for saving the cube model files during cube generation.
   ModelWorkDirectory	Any path on the Cognos 8 server, which will be used to store some temporary files during cube generation.

   
   

2. Go to <Argus Insight Directory>\ArgusInsight\Cognos\Cubes\BatchGeneration-Cubes folder.

3. Open the GenerateCubes.cfg file.

4. Set the following parameters in the GenerateCubes.cfg file:

   
   

   Parameter	Description
   ArgusInsightPath	This is the Argus Insight installation path; include the ArgusInsight folder in the string: <Argus Insight Installation path>\ArgusInsight
   CognosPath	This is the location of the Cognos 8 installation bin folder: <Cognos 8 installation path>\c8\bin
   ServerName	This is the name or IP address of the Cognos 8 server. If the Cognos 8 server is running on a port other than the default port, then the parameter values should be entered in this format: ServerName:PortNumber. For example, Cog8Server:9300
   CubeSaveDir	This value corresponds to CubeSaveDirectory attribute of Coggtr.xml file. This value will be same as value of CubeSaveDirectory in Coggtr.xml file i.e. <Argus Insight Installation path>\ArgusInsight
   CubeDataSourceDir	This value corresponds to DataSourceDirectory attribute of Coggtr.xml file. This value will be same as value of DataSourceDirectory in Coggtr.xml file i.e. <Argus Insight Installation path>\ArgusInsight

   
   

5. Restart the Cognos configuration services after applying the above settings.

8.3.2 Configuring Series 7.4 Cubes in an Unshared Environment

Use the following procedure to configure Series 7.5 Cubes in an unshared environment,

1. Configure the trnsfrmr.ini file as shown below.

   
   

   The following table describes the new parameters in this file:

   Parameter	Description
   CubeSaveDirectory	This is the path on the cube server for storing the output file generated as result of cube generation process. This is the path of the Argus Insight installation directory in a non-shared environment. It provides the relative path for saving the cube output files on their exact location.
   DataSourceDirectory	This is the path of the Argus Insight installation directory. This provides the relative path for the data source files which are used for cube generation.
   DataWorkDirectory	Any path on the Cognos Cube server, which will be used to store some temporary files during cube generation.
   LogFileDirectory	Any path on the Cognos Cube server, where all the cube generation log files will be saved.
   ModelSaveDirectory	This is the path of the Argus Insight installation directory. This provides the relative path for saving the cube model files during cube generation.
   ModelWorkDirectory	Any path on the Cognos Cube server, which will be used to store some temporary files during cube generation.

   
   

2. Go to <Argus Insight Directory>\ArgusInsight\Cognos\Cubes\BatchGeneration-Cubes folder.

3. Open the GenerateCubes.cfg file.

   
   

4. Set the following parameters in the GenerateCubes.cfg file:

   Parameter	Description
   ArgusInsightPath	This is the Argus Insight installation path; include the ArgusInsight folder in the string: <Argus Insight Installation path>\ArgusInsight
   CognosPath	This is the location of the PPES installation bin folder: <PPES installation path>\cer5\bin
   ServerName	This is the name of the Cognos Cube server. If the Cognos Cube server is running on a port other than the default port, then the parameter values should be entered in this format: ServerName:PortNumber. For example, CubeServer:8010
   CubeSaveDir	This value corresponds to CubeSaveDirectory attribute of trnsfrmr.ini file. This value will be same as value of CubeSaveDirectory in trnsfrmr.ini file i.e. <Argus Insight Installation path>\ArgusInsight
   CubeDataSourceDir	This value corresponds to DataSourceDirectory attribute of trnsfrmr.ini file. This value will be same as value of DataSourceDirectory in trnsfrmr.ini file i.e. <Argus Insight Installation path>\ArgusInsight

   
   

5. Restart the configuration manager service after applying the above settings.

8.3.3 Configuring Cognos 8 Cubes in Shared environment

1. Configure the Coggtr.xml file as shown below.

   
   

   The following table describes the new parameters in this file:

   Parameter	Description
   CubeSaveDirectory	This is the path on the cube server for storing the output file generated as result of cube generation process.
   DataSourceDirectory	This provides the relative path for the datasource files which are used for cube generation.
   DataWorkDirectory	Any path on the Cognos 8 server, which will be used to store some temporary files during cube generation.
   LogFileDirectory	Any path on the Cognos 8 server, where all the cube generation log files will be saved.
   ModelSaveDirectory	This provides the relative path for saving the cube model files during cube generation.
   ModelWorkDirectory	Any path on the Cognos 8 server, which will be used to store some temporary files during cube generation.

   
   
   
   

   Note: The path for the DataSourceDirectory and the ModelSaveDirectory should always be same whether they are in a shared or unshared environment.

   
   

2. Copy the COGNOS folder present under <Argus Insight Installation Directory>\ArgusInsight folder and paste the entire COGNOS folder on the path provided for DataSourceDirectory and ModelSaveDirectory attributes.

3. Make sure that path provided for CubeSaveDirectory exists on the server.

4. Go to <DataSourceDirectory>\Cognos\Cubes\BatchGeneration-Cubes folder.

5. Open the GenerateCubes.cfg file.

   
   

6. Set the following parameters in the GenerateCubes.cfg file:

   Parameter	Description
   ArgusInsightPath	This is the Argus Insight installation path; include the ArgusInsight folder in the string: <Argus Insight Installation path>\ArgusInsight
   CognosPath	This is the location of the Cognos 8 installation bin folder: <Cognos 8 installation path>\c8\bin
   ServerName	This is the name or IP address of the Cognos 8 server. If the Cognos 8 server is running on a port other than the default port, then the parameter values should be entered in this format: ServerName:PortNumber. For example, Cog8Server:9300
   CubeSaveDir	This value corresponds to CubeSaveDirectory attribute of Coggtr.xml file. This value will be same as value of CubeSaveDirectory in Coggtr.xml file i.e. <Path of CubeSaveDirectory>.
   CubeDataSourceDir	This value corresponds to DataSourceDirectory attribute of Coggtr.xml file. This value will be same as value of DataSourceDirectory in Coggtr.xml file i.e. <Path of DataSourceDirectory >

   
   

7. Schedule the cubes for generation using files present in the <DataSourceDirectory>\Cognos\Cubes\BatchGeneration-Cubes folder. Demand cubes will be scheduled using CubeGenMonitor.exe file present under <DataSourceDirectory>\Cognos\Cubes\PublishDemandCube folder.

8. All other configurations remain same.

9. Restart the Cognos configuration services after applying the above settings.

8.3.4 Configuring Series 7.4 Cubes in Shared environment

1. Configure the trnsfrmr.ini file as shown below.

   
   

   The following table describes the new parameters in this file:

   Parameter	Description
   CubeSaveDirectory	This is the path on the cube server for storing the output file generated as result of cube generation process.
   DataSourceDirectory	This provides the relative path for the datasource files which are used for cube generation.
   DataWorkDirectory	Any path on the Cognos Cube server, which will be used to store some temporary files during cube generation.
   LogFileDirectory	Any path on the Cognos Cube server, where all the cube generation log files will be saved.
   ModelSaveDirectory	This provides the relative path for saving the cube model files during cube generation.
   ModelWorkDirectory	Any path on the Cognos Cube server, which will be used to store some temporary files during cube generation.

   
   
   
   

   Note: The path for the DataSourceDirectory and the ModelSaveDirectory should always be same whether they are in a shared or unshared environment.

   
   

2. Copy the COGNOS folder present in the <Argus Insight Installation Directory>\ArgusInsight folder and paste the entire COGNOS folder on the path provided for DataSourceDirectory and ModelSaveDirectory attributes.

3. Make sure that path provided for CubeSaveDirectory exists on the server.

4. Go to <DataSourceDirectory>\Cognos\Cubes\BatchGeneration-Cubes folder.

5. Open the GenerateCubes.cfg file.

   
   

6. Set the following parameters in the GenerateCubes.cfg file:

   Parameter	Description
   ArgusInsightPath	This is the Argus Insight installation path; include the ArgusInsight folder in the string: <Argus Insight Installation path>\ArgusInsight
   CognosPath	This is the location of the Cognos 8 installation bin folder: <PPES installation path>\cer5\bin
   ServerName	This is the name of the Cognos Cube server. If the Cognos Cube server is running on a port other than the default port, then the parameter values should be entered in this format: ServerName:PortNumber. For example, CubeServer:8010
   CubeSaveDir	This value corresponds to CubeSaveDirectory attribute of trnsfrmr.ini file. This value will be same as value of CubeSaveDirectory in trnsfrmr.ini file i.e. <Path of CubeSaveDirectory>.
   CubeDataSourceDir	This value corresponds to DataSourceDirectory attribute of trnsfrmr.ini file. This value will be same as value of DataSourceDirectory in trnsfrmr.ini file i.e. <Path of DataSourceDirectory >. This is the path where we have copied the entire COGNOS folder from Argus Insight installation directory.

   
   

7. Schedule the cubes for generation using files present in the "<DataSourceDirectory>\Cognos\Cubes\BatchGeneration-Cubes" folder.

8. Demand cubes will be scheduled using "CubeGenMonitor.exe" file present under "<DataSourceDirectory>\Cognos\Cubes\PublishDemandCube" folder.

9. All other configurations remain same.

10. Restart the configuration manager service after applying the above settings.