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 |
what is the use of layout component reference
------------- How to identify the Revenue Column in Report?
----------------------What are the User Securities?
what is cube size?
-------------How to create a PortalTab?
how u publish the packages in framework manager
data import to models, datastores,stored processed, is there any other way to import data?
2.How do you drill through report from Report Studio to Analysis studio?
Column level security in report
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
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.
What are different events in Report studio?