Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between aggregation and role up aggregation ?
- 1 Answers
- 5107 Views
- Systime, I also Faced
- E-Mail Answers
Answer / 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 |
I have two date promts which optional. by defalt it will be checked.i want to unchek that date prompts.How to uncheck the date prompts in cognos
These are few Interview questions i faced.I hope to get help here. 1.Can we convert a Crosstab to List? 2.How do you approach and who tells you what exactly the way report has to be developed so that i meets the client requirements? 3.Can we link the List and Chart thats created in the same report? 4.Where do you edit sql in cognos8 ? 5.What is the difference between native sql and oracle sql? 6.What is the difference between MOLAP and ROLAP? 7.What is the use of BI in datwarehousing? 8.What are set functions? 9.How do you test a report? 10.What are the variables you find in toolbox? 11.How many types of filters are there in cognos8? All the answers r welcomed .U can reach me at vinod.davala@gmail.com
i want to create a crosstab report where product will be on rows year on column and revenue on measure. based on the users selection in value prompt, if user select the August 15, crosstab year column should display values for aug 15, aug 14, aug 13 and aug 12 i.e for last for years but same month. how could we achieve this?
suppose i want to do drill through a column only for the values which is having more than > 50000. how can i do that?
how u burst the reports? if u r bursted reports is not reached to destination how u identify???
Hi,please suggest me how to creat username while creating a report.
What do you understand by user class in cognos?
what are the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet?
1.How can we driil through from a page report having query1 to list report having Query2 in master detail relationship n Drill through? 2.In database i have 50 records but when it is displayed on the report i'm getting 100 record with duplictes.How can we solve this to eliminate duplicates? 3.Exact Diff B/W Filter n Condition? 4.Render Variable? 5.I have leftouter join when right table does not have any matched records with left table what will be the output of the report whether it will be dispalying Null or blank in that particular row? 6.How to test the reports i.e Unit Testing? 7.How canwe drill through when there is no common column between the parent n child report? 8.How can we do performance tuning? I kindly request all the experts to give reply with correct answers and if possible send me some examples regarding that at srini.madhala@gmail.com
what is filter?give me one example that you created a report in your project?
Please explain the different stages in creating a report in cognos report net?
It is possible to select more query items in value prompt? i.e when i use drag down i want to display these items like customerid in customer query subject, employeeid in employee query subject and orderid in order query subject..?becoz i want u display when i select a value(ex:customerid)in value prompt ,i need to display another report for all details customer.So, i need how to link for that process...? pls tel me any one knows ,i want to create that report..? thanks , basha
Teradata 
