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

 

Cognos Analytics 11.0.7 - Set Auto Group and Summarize Default = NO

Started by DeeGracie, 21 Jan 2018 07:29:08 PM

Previous topic - Next topic

DeeGracie


Is there a way to set auto group and summarize to NO by default.  I know this can be done in Cognos 10 as per the link below ... however while that file exists in C11 I can't seem to get it to work.  Has anyone tried this in Cognos 11?

http://www-01.ibm.com/support/docview.wss?uid=swg21616444

TomCognos

Are you talking about the following.

Top right of report studio click "..."
Click "options"
3rd tab "report"
5th check box down.
Untick "Automatic group and summary behavior for lists"

Ok I see the problem. If you use Notepad++ on the cognos analytics directory to search for the test autosummary within files you get a huge amount of entries coming back. No smoking gun though.

All i can say is the check box field is _2RH_chkAutoListGroupSummaryBehavior, found this through F12 on IE

Possibly can be set somewhere under D:\Program Files\ibm\cognos\analytics\webcontent\bi\schemas\rspec

Found the text ID IDS_AutoListGroupSummaryBehavior. Though unfortunately still no obviously set true to false anywhere.











DeeGracie

Thanks for your reply .. I have resolved as follows:

Automatic Group and Summary Behavior for Lists

Current Behavior
Click More
Options
Report
Automatic Group and Summary Behavior for Lists is checked off

Desired Behavior
Click More
Options
Report
Automatic Group and Summary Behavior for Lists is NOT checked off

Action

File name --> profile_titan.xml
Location --> D:\Program Files\ibm\cognos\analytics\webcontent\bi\pat\profiles

Set the following

from --> <setting name="AutoListGroupSummaryBehavior" defaultValue="true"/>
to ----> <setting name="AutoListGroupSummaryBehavior" defaultValue="false"/>


Our report authors have tested successfully.

Thanks

Denise

TomCognos

Didn't work for me. I tried both settings and restarted the services.

I'm on 11.0.9

All good. Will persist with the manual approach.

DeeGracie

It worked for us on 11.0.7 without having to restart the services.  We are planning to go to 11.0.9 in the near future so I guess I will be looking for a way to do it again .. :(