If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Grouptotals adding Multiple levels of Tree prompt in DMR report

Started by tarunkrdas2013, 06 Oct 2015 02:07:16 PM

Previous topic - Next topic

tarunkrdas2013



I have DMR cross tab report where Company is both dimension and hierarchy and crosstab node member is made as Summary(Company).
Problem is from Tree prompt when user selects only United States totals comes correct but when user selects Company(All) and also selects united states
Crosstab  node member sums up both Company and United states.

Expected result is when user selects Company(All) and also selects united states
Crosstab  node member should show only Company and not United states.

Actual result what is happening in report is when user selects Company(All) and also selects united states
Crosstab  node member  shows addition of  Company and  United states which is wrong

I have tried various classes of crosstab node member like crosstab fact cell (subtotal more+hidden) then crosstab member cell(subtotal excluded)
but nothing shows correct group totals

can any one suggest what can be done

tarunkrdas2013

SOLVED

Used prompt many to default Company(ALL) when user selects Company(ALL) and United states and instead of Crosstab Totals from tool used data item

1)For company promt wrote
set ( #promptmany ('p_Location', 'memberuniquename', '[Hierarchical].[Company].[Location].[Company (All)]->[all]')#)

2)Pulled [Company (All)] level from model to Query Item

3)Wrote data item with below expression
aggregate(currentMeasure within set [Company (All)])