Can any one give the example for slicing and dicing of
data ?(with simple query)

Answers were Sorted based on User's Feedback



Can any one give the example for slicing and dicing of data ?(with simple query)..

Answer / 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

Can any one give the example for slicing and dicing of data ?(with simple query)..

Answer / madhavi

Slicing is a vertical view of a report and
dicing is a horizontal view of a report. simple....

Is This Answer Correct ?    10 Yes 12 No

Can any one give the example for slicing and dicing of data ?(with simple query)..

Answer / neelima

example:consider a product example car and the ways
received orders.
product name order method
maruthi telephone booking
alto telephone booking
Mercedez telephone booking
maruthi fax booking
maruthi agent
.....

so when you do sliciing and dicing if you want to display
all the products sold through internet it will display all
product sold by internet booking.ie viewing the data in
different prespectives. we basically use this concept while
dealing with cubes.

Is This Answer Correct ?    6 Yes 10 No

Post New Answer

More Cognos Interview Questions

New coloums are added in database, then how you know in report level

0 Answers   Accenture,


diff b/w dimension and regular dimension

1 Answers  


What are the considerations regarding performance kept in mind while setting up cognos?

0 Answers  


What is called a slice?

0 Answers  


suppose i want to do drill through a column only for the values which is having more than > 50000. how can i do that?

2 Answers   Mind Tree,






which type of project we r going to snowflake schema

0 Answers   IBM,


what is repeater table and repeater where to use these? can any one explain with senario greatly helpfull

2 Answers   IBM,


Can u please describe the different types of traps with eg. Thanks

2 Answers  


Is cognos models are version compatible?

2 Answers  


What are query items?

0 Answers  


what is a Galaxy Schema?

2 Answers   IBM,


difference between imprompt and reportnwt1.1

2 Answers   HSBC,


Categories