Can any one give the example for slicing and dicing of
data ?(with simple query)
Answer Posted / ericmilic.com
Slicing -taking a specific segment of info out of the data. eg. total number of units sold for a product over a specific time frame
vs
Dicing - taking a specific segment but a more detailed view of info, eg. overall sales for specific product, produced by different mfg over specific time in specific region.
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
Define olap designer?
----------------Diff b/w Dimensional modeling and Relational modeling?
If we are migrating lower version of Cognos reports (e.g. from Ver 7.0 to Cognos 8) then how we migrate Impromptu Catalog (ver 7.0) in Cognos 8? Do we create FM model for that? Please explain.
1. We have been asked to add summary information to sales reprasentatives performance report. The report needs to be grouped by country and city to compare performance between areas Also we need to include revenue totals for each city and each country.
Please explain the different stages in creating a report in cognos report net?
Give the advantages of cognos?
what is requery in cognos?
how you create security to reports?
--------------Explain Table of contents?
Can you define slice?
what are the special features in cognos reportnet?
We can use a calculated field to dynamically create the burst recipients in Cognos 8. Can we do the same in Cognos ReportNet 1.1?
how many notations are posible(cordinolity)are there in between two tables(one is fact and another is dimension)pls give me a example pls.
Can you define snapshot?
--------------Diff b/w ODS and OLAP?