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 what three things do you consider to be the most important factors for a manager?

554


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!!!

1757


Explain what task is 98% of the required work of a business analyst?

600


Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye

1401


Give some information on report bursting?

571






Explain what are the steps to do to use alerts in bo?

615


What is report template in b.o?

588


Explain which versions are used in the bo dashboard work?

635


how to create metric universe ?

1897


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

608


1)I have createcd a dashboard on Bex query. How to refresh the Dashboard without hitting the bex query? 2)What is Event based scheduling in BO? 3) How to display the BO webi report title using a function? 4) For eg in my webi report iam having a person name like Jhon Peter Adam. But i need to get only the middle name of the person like Peter. What function is used in Webi to get this?

3132


WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S

1691


Which command using Query Analyzer will give you the version of SQL server and operating system ?

4189


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

579


What is the profile and package?

1767