Can any one give the example for slicing and dicing of
data ?(with simple query)

Answers were Sorted based on User's Feedback



Can any one give the example for slicing and dicing of data ?(with simple query)..

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

Can any one give the example for slicing and dicing of data ?(with simple query)..

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

Can any one give the example for slicing and dicing of data ?(with simple query)..

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

Post New Answer

More Cognos Interview Questions

what is the use of layout component reference

3 Answers   Satyam,


------------- How to identify the Revenue Column in Report?

0 Answers  


----------------------What are the User Securities?

0 Answers   IBM,


what is cube size?

4 Answers   IBM,


-------------How to create a PortalTab?

1 Answers   Cap Gemini,






how u publish the packages in framework manager

3 Answers   TCS,


data import to models, datastores,stored processed, is there any other way to import data?

1 Answers   TCS,


2.How do you drill through report from Report Studio to Analysis studio?

3 Answers   IBM,


Column level security in report

4 Answers  


I have a reports on cognos ep7series version3 with database SQl2000.Now i am migrating database SQL2000 to SQL2005.Then What happens to cognos reports and also there is reports cubes then how can i handle this problem please give me step by step solution b'coz i am new to cognos ep7series

0 Answers   Infosys,


What is the difference between Section and Section using Master/Detail in Cognos 8 Report Studio? I tried these both options many times on lists and crosstabs, but dint find any difference. So please give the answer in detail with example.

0 Answers  


What are different events in Report studio?

0 Answers   Wipro,


Categories