In this article, we will learn How to create First IBM Cognos Framework Manager (FM) Project?
First, we need to launch the IBM Cognos Framework Manager. If you are looking for the installation step for the IBM Cognos Framework Manager, please refer to this article.
On Windows, to launch IBM Cognos Framework Manager, click on Start Icon, Search for IBM Cognos FM Shortcut Folder. For us, it is IBM Cognos FM 10. Expand the FM Shortcut folder and select IBM Cognos Framework Manager.
On the first screen, we have multiple options to create a new Project. If you already have an existing project, we can also open the existing FM Project.
For creating a new Project we have multiple options. First, we can use the File menu. Second, we can also select the New icon from the toolbar. Third,
We have options on Welcome Windows. Finally, We can use the keyboard shortcut (Ctrl+N). Let's press Ctrl + N for creating our first FM Project.
Next, we need to provide the following information
1. Project Name: Provide a valid project name. For the first FM project, We used MyFirstProject.
2. Project Location: Provide a valid location for the new project. We selected the D drive. If you are in the restricted environment, then select the location where you have the proper privileges.
3. Project to be created: Based on the Project name and Project Location you check the final path for the project.
4. Use Dynamic Query Mode: For the first project unchecked it. We can learn more about the Dynamic Query Mode in the future article. If you are interested, you can check this article.
Finally, click on the OK button.
If Single Sign-On is enabled, then we need to provide the valid username and password.
Select Project Language.
Next window is for Metadata Wizard. We will work with a database so select Data Source.
Based on the selection of previous windows the options for the next window will differ. We selected the Data Source. On the next window, we will see all the available data sources. We need to select the data source from which we need to add the database tables, views or procedure. The data source must need to create first before importing the database objects. If you can't see any data source, then you can create one by clicking on the New button. For us, we have some data source available. But assume for you don't have any data source created yet. So let's first create a new data source. Then we will use it to import some database tables. Next window is for Metadata Wizard. We will work with a database so select Data Source.
Next, we need to provide a valid data source name. For the description and the screen tip, it is not mandatory, but as a best practice always provide a valid description and occasionally a screen tip.
Next, Select the Data Source type. We will use SQL Server. So we selected Microsoft SQL Server. Also right now we don't need to configure the JDBC connection so uncheck it. Again, we learn more about the JDBC connection in the future article. For the time being select SQL Server uncheck configure JDBC connection.
On the next page, we need to provide the data server information. Once you have provided the valid database server configuration test the connection. If the connection is tested successfully, click on the Finish button to create the data source.
Select the newly created data source and click on the Next button.
Select a single database table and click on the next button. Why single table? Currently, add a single database table. We will add more in our upcoming articles. Select the table and click on the next button.
Uncheck everything and click on the Import button.
Our first project is created successfully. In our next article, we will learn about IBM Cognos Framework Manager Project Files and User Interface.
Please login to post your valuable comments.