what is slice & dice?

Answer Posted / surajit ray

===SLICING===
Slicing, as the name suggest, is a slice of the actual cube that is created by taking a single value of one of the dimensions from parent cube. It is more like a filter applied.

===Dicing===
Dicing is grouping of a few dimensions to produce a subset of parent cube. Selective values are taken from different dimensions to produce the sub cube

Is This Answer Correct ?    8 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the data types present in bo and what happens if we implement view in the designer and report?

761


What is the difference between user and versatile user?

748


I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!

1943


how to create metric universe ?

2077


What are the steps to be taken to schedule the report?

716






Explain what would you consider as your biggest achievement and why?

742


How to generate the report from excel sheet?

814


Explain what three things do you consider to be the most important factors for a manager?

736


How many universes can be created in a project?

760


In banking domain how many Fact tables,Dimension table are present?

8559


Explain what is the difference between slice and dice and cross tab report?

786


When to use local filter and when to use global filter?

761


What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?

784


Explain what is the difference between business requirement document and use case document.

754


Differences between business objects and web intelligence reports?

832