Can any one give the example for slicing and dicing of
data ?(with simple query)
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
New coloums are added in database, then how you know in report level
diff b/w dimension and regular dimension
What are the considerations regarding performance kept in mind while setting up cognos?
What is called a slice?
suppose i want to do drill through a column only for the values which is having more than > 50000. how can i do that?
which type of project we r going to snowflake schema
what is repeater table and repeater where to use these? can any one explain with senario greatly helpfull
Can u please describe the different types of traps with eg. Thanks
Is cognos models are version compatible?
What are query items?
what is a Galaxy Schema?
difference between imprompt and reportnwt1.1