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 |
Interval Prompt's Usage? Example for usage in Project
what are the types of facts ? explain them?
2 Answers Business Objects, Informatica, Syntel, Teradata,
What are the Ways to Import Data into Catalong?
what are the applications of the tabular model ????
Explain the workflow of your current project from end to end?what is the steps?
2 Answers Accenture, Cap Gemini, Cognizant, HCL, IBM, Infosys, Nokia,
what is your project workflow and your role in the project?
how to find the rank in report studio? i need steps for this question.
How do we run stored procedure?
What is Lookup ,bridgeing tables where they will use in the Dataware house
What is meant by alternate drill down with ex?
what is an sid (surrogate key)?
What is use of Field Set present in toolbox?