1.How to apply sorting to Crosstab report? If so please give
me example?
2.How to create Report level Joins?explain with example?


Answer Posted / timekeeper

Suppose take a product table containing product name and
product no.product number to column and product name to row.
select the column name product and sort it using the sorter
given in the tool bar either in Ascending or in Descending.

Is This Answer Correct ?    2 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is set to be cardinality?

638


What are the different types of important services used in cognos?

585


How to generate the Catalog in Cognos? Basically all post describing generating the Catalog from cognos impromptu . Is there any way to generate the Catalog using Cognos Administration or Framework Manager?

1543


Give the advantages of cognos?

575


What are the types of studio present in Cognos?

613






Source table has 5 rows. Rank in rank transformation is set to 10. How many rows the rank transformation will output?

588


Can you explain a cognos controller?

597


What is the difference between a data mart and a data warehouse?

545


describe the starschema grouping ?how can i add a new column for existing report ,when it is not present even in model & dataabase?

1897


What are shortcuts? Where it can be used? What are the advantages?

551


How to select multiple values from type-in prompt?

642


if ur report having report filter save the report.open u r report in cc the report filter doesnt work means it does n't any values what we do for this situation?where we rectify this?please please ans me......

1530


What do you understand by the term ‘frame manager' in cognos and write all the layers of the framework manager model?

716


what is degenerate key in oracle ?whare do we use it?

2061


Why need staging area database for dwh?

642