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 are the differences between cognos 8.2 and cognos 8.4? Please help me..
Can we create a web page where the report directory and the output can be viewed directly across cognos connection?
What is the difference between Open Connection command ang Open Session Command?
hi frnds any body have cognos projects plz send me two(or)three projects to my mail adress ramureddy.reddy4@gmail.com.
1.Can we create a cube in a Transformer from multiple IQD's ?if so, how? 2.Also , explain some of the best practises used ,while creating a cube in powerplay transformer.
what is the meaning of aggregation and rollup aggregation? Difference between layout calculation and query calculation? How do you hide the rows that have null values? why we use query studio? what is the use of query studio compared to report studio?
After generating value prompt,when we run the report... then we will get the prompt in the output.. Along with that prompt we will get diff types of symbols highlited......How can we hide those symbols?
What is a dimension?
Diff b/w Crossproduct and Outerjoin?
hi,dis is kumari.I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out. my mail-id is vicky_ceti@yahoo.co.in hope u will respond as soon as possible. thank u in advance
What is difference between drill through and drill down?
If we run a report, that has 2 pages, i want to display one page in HTML format and another page wil display in pdf format. What is the procedure?