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.


Thursday, June 5, 2014

Cognos 10.2.1 DQM DMR Defects - Part 2

Drill and Re select Dimension with Render Variable - Behaves differently if measure is based on data item vs measure based on prompt macro.

If 2 members are defined - one with a token prompt macro and another with an MDX expression defined on top of the first data item. If member sets are defined on the 2 members and drill behvaiour set for the first member to replace expression and the second expression to preserve. Drill up/down on one dimension and then resetting dimension and then drilling up/down does not work.

Prompt Macro and MDX Expressions - topCount with token prompt macro

Not all MDX expressions work on prompt macro. topCount does not work on a data item that has #prompt(,'token')#.

Prompt Macro and MDX Expressions - roleValue with MUN prompt macro

Not all MDX expressions work on prompt macro. roleValue does not work on a data item that has #prompt(,'memberUniqueName')#.

Periods to Date does not work as expected with any expression in the 2nd argument in CQM mode.

It has to be a member for the right result to be returned. Even if the expression returns a member, PTD does not work correctly and returns only one period. This is only in CQM mode.

I will list out a couple of Workspace defects in the next article.