by S-Square | Dec 9, 2019 | Blogs
What is parameter map: Parameter map is a set of Keys and Values that could be used to substitute values while running the query. We can create parameter maps manually and based on query items. Steps to create a parameter map: Open framework manager. Click on the .cpf...
by S-Square | Dec 5, 2019 | Blogs
A pie chart represents data as slices of a circle with different sizes and colors. The slices are labelled and the numbers corresponding to each slice is also represented in the chart. You can select the pie chart option from the Marks card to create a pie chart. By...
by S-Square | Sep 11, 2019 | Blogs
In Cognos framework manager, we can implement securities is a way of restricting access to the metadata or data from the users while accessing the reports. There are three different types of securities we can implement in the Cognos Framework Manager. The securities...
by S-Square | Sep 10, 2019 | Blogs
Structured Query Language (SQL) is known as the database language. SQL commands are instructions, coded into SQL statements, which are used to communicate with the database to perform specific tasks, work, functions and queries with data. SQL commands are mainly...
by S-Square | Sep 10, 2019 | Blogs
The Like operator is used to search the pattern in one table. Similarly, we can use the like operator along with the concatenation function to do a pattern matching between the multiple tables. Here I have given example for two tables. Examples: Here I have created...