what is the difference between list sequel and cross tab
sequel?
Answers were Sorted based on User's Feedback
Answer / ashok
As of My Assumption you are talking about the sql's generated for Lists and Crostabs.
Here is the answer
List: List SQL gives us the detail kind of Information in the Query
Crostab: Crosstab SQL gives us the Summary Kind of information for the intersection of rows and Colums.
Is This Answer Correct ? | 0 Yes | 3 No |
---------------Describe OLAP Reporting and RDBMS Reporting?
using of matric studio we can developed to scorecard ... what is the meaning by scorecords
what type of charts we create mostly in realtime? plz help
I have Date,product,Quantity_Sold columns and I want Product, MTD(month Till date),YTD(Year Till Date) as output. Can anyone help me with the logic in getting MTD i.e quantity sold from 1st of this month to till date (i.e. 01- 11-2013 to 26-11-2013) and YTD i.e QTD sold from 1st date of the year to till date(i.e. 01-01-2013 to 26-11-2013). Sample output model: Product MTD YTD
What do you understand by the term 'dynamic cube'?
How do we run stored procedure?
What is called materialized view?
Did you find any differences in bursting feature between reportnet 1.1 & cognos 8? what are the differences?
What is a scope? can you tell me one example for scope?
What are the best practices while building a Cognos Framework Manager Package ? As in, what calculations would you not like to be handled in FM and rather get it directly from Database.
what is report burn and where it occurs
pls ans what are the filters we have in framework manager? filters in report studio?