what is the difference between aggregation and roll up
aggregation?
Answer Posted / magiccube
Aggregation: It will sum up all group column data.
Rollup Aggregation: It will sum up Groupwise data.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What's the limitation of 'Page Footer' in Report Studio? e.g. If I have an activity prompt (list of activities in a Search & Select Prompt) and selected around 2500 activites from the 'Activity' Search & Select Prompt and when I ran the report I got a message "#! Overflow" in page footer. Can somebody please tell me what's max. limit. I tried with around 300 activities and page footer displayed the activities. Your help will be appriciated.
Can the expiration parameter of 365 in the cognos 8 configuration how to increase common symmetric key lifetime in days
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
Why are meta service important then other services?
I have a reports on cognos ep7series version3 with database SQl2000.Now i am migrating database SQL2000 to SQL2005.Then What happens to cognos reports and also there is reports cubes then how can i handle this problem please give me step by step solution b'coz i am new to cognos ep7series
I have 7500 rows. I need all rows in single reports. Which type of prompt we have used retrieving all rows and show in a report? We have dynamical queries q1, q2, q3, q4, q5. If customer selects the particular, query that only show in execution report. In case it may more then one, how do you execute the particular query item in report page? What are the difference bt OLDP and OLAP?
how the values be passed to prompts in report studio? when a data item is dragged n dropped in to report, after the default query generated first which sql will the query query hit for processing means (native or cognos)? plz answers to these questions?
What is difference between page break and section report? What is main advantage datawarehousing over oracle?
What are all the types of gateway used in Cognos?
How we check the errors before running the report?
What is the advantage of using shortcuts?
What are the considerations regarding performance kept in mind while setting up cognos?
what is the role of cognos comsultant?what actually it means?pls reply
What is main advantage datawarehousing over oracle?
Re: hi,dis is Hari.I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out. my mail-id is shankerhari17@yahoo.com, hope u will respond as soon as possible. thank u in advance