RE: 1.diff between drill down and drill through?...
Drill Down - an action that shows the child categories
Drill Through - A n action that uses the current context of a report, to access information in anotherreport, cube, Impromptu report, or macro. Cubes with drill-through access are set up in Transformer and must match on of dimensions, measures, and details, although not necessarily all of them.
RE: 1.diff between drill down and drill through?...
Hi
Ans of Quest. 7 - Alternate drill down path means there will be two path to opt.For example- We will have time dimension now the client requirement is they want two type of year -one is claender year(Jan-Dec) and another is fiscal year(Apr-Mar).
Now wil have to create a alternate drill down for year.so user can drill down with using cal yr to quarter to month to week or fiscal yr to quarter to month to week.
RE: 1.diff between drill down and drill through?...
Drill-through report is to link two reports containing related information. You can thenaccess related or more detailed information in one report by selecting a value in another report.Drill down report allows the reader to drill down to lower level data sets and drill up report allows to drill up to higher-level data sets, provided you are using a dimensionally modeled data source. This will allow you to rerun the report for a different dataset without having to regenerate the report.An example of a dimensional hierarchy might be:Years - Year - Quarter - MonthDrilling up and down allows you to view more general or more detailed information on your datawithin such a predefined dimensional hierarchy, without having to create different reports.