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
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
product name order method
maruthi telephone booking
alto telephone booking
Mercedez telephone booking
maruthi fax booking
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|
What r the names of the reports that you prepared?
What do you do to make a report result in showing 4 different regions in an xl sheet in individual sheets(like Region1-sheet1,Region2-Sheet2 soon)?
what is the difference b/w mdx and sql?
What is Cardinality
How to schedule the report twice in a day?
Define query studio?
Hi Friends, Please tell me at What situations we use the Segment, Link in FM, What is the Main Difference functionality wise? Thank You
hi, i am Having 2 Reports one list report,one crosstab report if i put 2 querys for 2 reports which query will execute first?if i put same query for both 2 which report i will Get?pls pls pls Explain me...
What are the steps to create DMR model in FM? Give me brienf discription as interview point of you?
write the sql query to display 5th and 10th row in a table?
How to Create users in cognos Access Manager from 1) front end 2) back end
what is differences between the group span and levelspan