Please give a brief summary on slicing and dicing. Please include these topics in the summary:...

Question

Question

Please give a brief summary on slicing and dicing. Please include these topics in the summary: techniques, mistakes, pivot charts and tables. OLAP

engineering Computer-Science

Answer 1

Answer #1

Slicing refers to choosing one of the dimensions as a reference for the cube in OLAP and producing a smaller cube with respect to it which will be one dimension less than the OLAP.
Suppose there are three dimensions time, item type and location. In the case of slicing, a particular time is taken and a graph is prepared between the item type and location.
Dicing refers to the choice of two or more values from the multidimensions and then the whole cube is rotated.
Thus, a detailed analysis can be done using both techniques.
In the case of Pivot tables and pivot charts.analysis can be done based on the conditions that can be implemented using customization or recommended pivot tables or charts. Slicing and dicing is done on these data so that analysis can be done
There may occur slicing and dicing that may not result in a fruitful analysis. So, before slicing it should be clearer what needs to be analyzed.

Friend, this was a really nice question to answer. If you find my answer helpful, please like it. Thanks.

Answer 2

Similar Homework Help Questions

Task: Executive Summary base on Ford Motor Company (APA format) Please give brief info on Ford Mo...

Task: Executive Summary base on Ford Motor Company (APA format) Please give brief info on Ford Motor Company background, current hiring process, and how to improve. Please include work cited/resource link
Please select one from the following topics below. Discuss and give a summary, an example, and...

Please select one from the following topics below. Discuss and give a summary, an example, and how it affects nursing or patient care. The post should be 4-5 paragraphs and be detailed and specific. please citation your work or reference. 1 - Informed Consent 2- Assault and battery 3- Mandatory reporting 4- Malpractice 5- Confidentiality (HIPPA) 6- Autonomy 7-Patient rights 8- Beneficence and Nonmaleficence 9 - Justice 10- Veracity 11- Code of Ethics for Nursing by the ANA 12- Role...
Describe the Nuremberg Code. Provide a brief summary of it, and include the history of the...

Describe the Nuremberg Code. Provide a brief summary of it, and include the history of the code. How does the Nuremberg Code compare to the other medical professional code of ethics?

Give a brief summary of the history of individual health insurance mandates in America.

Give a brief summary of the history of individual health insurance mandates in America.
Write a brief summary on one type of skin cancer. Include in your summary how this...

Write a brief summary on one type of skin cancer. Include in your summary how this type of cancer could be prevented and how it is treated. Post one lifestyle change an individual can make to lessen their risk of developing skin cancer. Does living in the Midwest increase or decrease our chances of developing skin cancer? Who is at risk? What are your thoughts?
research Wc regulations in New York and give a brief summary of what is found

research Wc regulations in New York and give a brief summary of what is found

research the current status of this Disney design decision, and include a brief summary in your...

research the current status of this Disney design decision, and include a brief summary in your write-up (no more than two typed pages).
Research WC regulations in New York and give a brief summary of what you found.

Research WC regulations in New York and give a brief summary of what you found.
Read three recent news articles about passwords and write a brief summary. Include a reference to...

Read three recent news articles about passwords and write a brief summary. Include a reference to each article.

Drug Tests for Welfare Recipients- Research this topic and include a brief summary and your opinion....

Drug Tests for Welfare Recipients- Research this topic and include a brief summary and your opinion. A well written answer will include the problems associated with the concept, as well as the conflicts regarding the law. Your submission should be approximately one-page in length.