[AS] drill-to issues

[Blue]

G'day all

We have found some particularly annoying issues with cube-to-cube drill throughs in Analysis Studio.

1. Relative time - category codes will not map correctly to drill-to prompts (context filters) in target analyses.

2. Performance - complex target analyses with several drill-to prompts (context filters) will take a long time to load - 40 seconds or more (deepest dimension only 5,500 rows).

3. Target analysis will be filtered based on category codes sent from source analysis but columns will not be altered to display only relevant values.  E.g. If the analysis has been set up using years as the columns (say you have 2004, 2005, 2006) and the drill-to filter is for June 2006 the analysis will still display all 3 years even though the data is constrained to a particular month.  I would expect to see the columns altered to display only June 2006.

If you have any work-arounds or fixes for these issues I would love to see your repsonse!

Blue