what is stitched query???
Answers were Sorted based on User's Feedback
Answer / vamsi
fm generates separate query for each fcat table and joins
them internally at database level this is called
stichedquery
Is This Answer Correct ? | 9 Yes | 3 No |
Answer / rao
Stitch Query is used to handle multi-fact tables.
Stitch Query joins two fact tables by using conformed dimension and we use outer join to retreive all records from both fact tables.
Is This Answer Correct ? | 0 Yes | 0 No |
Define cognos report net?
we have a column of int/varchar datatype,but when we run the report we should get the date format i.e., suppose date key is a query item consists of data as 20040105,20030503,20060410....... output should be 5 jan 2004,3 may2003,10 apr 2006..........respectively.Can i knnow the answer
in u r data u having duplicates how to fetch the latest data in our report?
What is Fullouterjoin?
Can we create 2 conditions in report expression of a single data item..Eg: I added 2 new dataitems each one should show revenue for Q1 and Q2..Pls advice
I have created a database "TestingDB" in MS SQL Server 2005. I have set the port properties and the Cognos Service is up. But I don't see anything in the Cognos. In the administration i have set the ODBC connection and it tested successfully.If i copy the samples to the appropriate directory then i can see the samples.But I don't know how to do the same thing with my own database "TestingDB". As i have configure the cognos in my company which is having a database (very near to production database).I am a novice in cognos. Please help me out.
Define the slice and dice?
what is field set? what is the query calculation and layout calculation?
-----------Diff b/w OLAP and RDBMS?
What is meant by Reportstudio shortcut?
How can we publish package to QA environment not cognos connection?(if we have two URL one cognos connection and qa environment how can we publish package to qa?)Please anybody give me the answer.
In a Single page we are having 3 list. While running each has to populated in separate page?