Tuesday, June 10, 2014

10.2.1 Defects - Workspace

The below are against 10.2.1 DMR model using DQM mode.

For most of the defects the report has a crosstab with prompts on the report page to dynamically select rows and measures and a period tree prompt to select the period columns. The report has drills enabled.

Again, will update defect numbers as we get them. But that seems to be a time consuming process and am not the one involved.

Drill through lost on drill down

Drills not synched between chart and crosstab - Drill down on Product, Quarter combination in chart does not get reflected in crosstab

Drill on measures not synched between chart and crosstab - Drill down on fact cell intersection on chart does not reflect correctly in crosstab

Drill up and re-prompt doesn’t get reflected - Drill up on first run of the report and reset dimension. New dimension does not get reflected in objects

Resetting prompted widgets will re-prompt and then selecting different prompt values does not have any effect on the widgets.

Drill up/down and drill through doesn't pass all context values to the drill through report.

Charts - Drill and prompt on the same hierarchy does not reflect once drills are enacted - If a prompt dimension is used as series or categories then once a drill is acted upon the series/category re-prompting does not have any effect.

Drills get enabled and disabled intermittently on categories/rows and series/columns - Initially chart, crosstab do not have drills enabled on the time period series as set up in the report. Once drills are executed on the fact cells or on the chart intersections the drills become enabled on the time series.


2 comments:

Monstermurtuza courseshussain said...

Great information is been provided, i thank the blogger for implementing these ideas and explaining it here in a much better way, i have learned alot on Cognos from here, when i was getting trained by monstercourses online , there experts teach you in a much excellent way, pls visit: http://www.monstercourses.com/courses/data-warehousing/ibm-cognos-online-training

oracleR12 said...

Hi,
Great information is been provided, i thank the blogger for implementing these ideas and explaining it here in a much better way. I am glad that you shared this information with us.
oracle EBS training