Can any one give the example for slicing and dicing of
data ?(with simple query)
- 3 Answers
- 19418 Views
- Cognos, I also Faced
- E-Mail Answers
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 |
15. If I select the current month and year how can we display previous 11 months data?
Is cognos models are version compatible?
hai frndz....... in a product name QUERY ITEM column we have some products like..soap, mobile, laptop, nd so on..... when i report run for the US client with the product name,, langauge is requird only ENGLISH.... IF client as a chaina .or, japan .or, spanish.. they want to run report using by product name QUERY ITEM as thier region language like chaina/japan/spanish... how to i convert product name column as default as english, to chaina/japan/spanish..........in the framework manager/ cognos connction Could u pls give me problm solution.....thnx in advnce........
what are the joins present in reportnet?which is most widely used?
fiscal year means what???
can anybody explain me about sales project in cognos..wt is the requirement,how u get the requirement..explain me any one based on ur experience as a report developer..how much time u will take to complete one project,single person in a team have to do how many reports..in a real time how much time will take to complete reports ie..one single report.. (simple and complex report)and in real time ur project contains how many fact tables and dimension tables..how many query subjects and query items..wt functional area u worked on.. hope u vl respond as soon as possible ..my mail- id is ammu2india@gmail.com
what is alias what is shortcut what ia alias shortcut and diff among them if u know explain clearly
5. Which type of report you build more, list, crosstab or chart and why?
11. Which is a collection of data defined in Analysis Studio that can be saved and reused in the same analysis? a. Custom set b. Predefined set c. Level based set d. Measure set 12. In a list report in Report Studio there are 3 columns A,B,C and they are grouped by Col A. To show the values of Col A for every value of Col B , which of following steps should be taken? a. Ungroup b. Set Group span to Col A c. Set Group span to Col B 13. Which of following cant be set as a Governer in FM? a. no of tables to b selected in a query b. Left outer joins c. No of Columns to be selected in a query d. Cross Product joins 14. Purpose of analysis studio? a. To provide interactive reporting capability b. All the options c. To generate complex reports d. To help in more trend analysis 15.How to suppress Nulls in Analysis Studio reports? a. Choose the suppression as TOTAL > 0 b. Choose the suppression as TOTAL is NULL c. Choose the suppression as TOTAL is ZERO d. Choose the suppression as TOTAL is not NULL 16.Frame work Manager cant import Metadata from which of folowing? a. Decision Stream b. XML datasource c. Impromptu Catalogs d. Excel Sheets 17. In a report, to perform aggregation using aggregator expression, what should we use? a.Aggregation LIst b.Aggregation type c.Aggregation mode d. None 18. What is the role for gateways? Thanks in Advance
What is Crossproduct?
Can you define pivot?
where do we see the run time of the report ?
Teradata 
