Steps
1. Create a New Project in Framework Manager
2. Right-click on the namespace under Project Viewer and
Create a Query Subject as shown below.
3. Give the name as Product and select the type as Data Source.
4. Select great_outdoors_sales and click on Next.
5. Add the following columns from Product Line and Product Type as shown below.
6. By default, Cognos FMW suggest the possible joins that can be created in between the two tables we have selected.
7. You can also add a filter condition for the query subject that is created.
8. Next screen will show you the SQL created for the data source query subject.
No comments:
Post a Comment