Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between aggregation and role up aggregation ?
- 1 Answers
- 5123 Views
- Systime, I also Faced
- E-Mail Answers
Answer Posted / suresh
Hi,
Aggregation is normal aggregation like we do in SQL
query(Total,Avg,Count,Max,Min,Sum).
Rollup aggregation is at the end what should do for the
total report.
for example below:
Country Quantity
India 10
India 24
Singapore 6
Malaysia 4
when you group this report Aggregation for India
34,Singapore 6,Malaysia 6 and Rollup aggregate for this
report will be 44 calculated
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What do you understand by the term 'aggregate cache'?
What is main difference mapplets and mapping?
----------------Diff b/w Dimensional modeling and Relational modeling?
What is difference between primary key and unique key constraints?
How can we create a dynamic column name in cognos?
Explain the difference between native sql and cognos sql?
What is the difference between regular dimension and derminant?
What is the difference between the content store and content manager?
------------------What is Inline Query?
What is the difference between set functions and filter function in dimensional data?
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.
What is a Transformer?
What are various types of gateways in cognos?
What is cognos reporting tool?
What are all the different types of prompt in cognos?
