topic Re: Totals and Subtotals in SAS Web Report Studio

Totals and Subtotals

Bala — Wed, 16 Dec 2009 12:45:43 GMT

Hi,

I am new WRS. I have report with 4 dimension as rows and some measures on columns. When I try to get subtotals and total for them . It is not displaying. But when I am reducing rows to 3 . It is giving subtotals and totals .

Currently we are using WRS 3.1. can any one advice me how to get subtotals and totals when I am having 4 dimensions.

Thanks in advance.

Thanks,
Bala

Re: Totals and Subtotals

Madelyn_SAS — Wed, 16 Dec 2009 14:20:09 GMT

It is possible that you are running into this issue: http://support.sas.com/kb/35/464.html

There is a hot fix available.

Re: Totals and Subtotals

Bala — Thu, 17 Dec 2009 12:35:08 GMT

This Hot Fix is for WRS 4.2 . but currently we using WRS 3.1.

Re: Totals and Subtotals

deleted_user — Tue, 12 Jan 2010 17:03:02 GMT

We've also runned into this problem, but we had an error message (MDX). The SAS note related to this problem is the following : http://support.sas.com/kb/16/268.html

Sorry, nothing to do!

Re: Totals and Subtotals

Jenn2 — Tue, 12 Jan 2010 21:14:22 GMT

Bala,
I tried to reproduce the error and could not get what you are describing. I'm going to keep looking for documentation.
Jen

Re: Totals and Subtotals

Jenn2 — Tue, 12 Jan 2010 21:21:08 GMT

I pulled up this hotfix: http://support.sas.com/kb/20/713.html
May not help.

Re: Totals and Subtotals

Bala — Sat, 16 Jan 2010 12:50:10 GMT

I think this is for diffarent issue. I rasied a track with SAS and They told that It is not possible to display totals and subtotals if we are selecting more then 4 diemsions in a row.

Thanks,
Bala

Re: Totals and Subtotals

louise — Mon, 12 Jul 2010 10:36:49 GMT

Hi Bala,

Did they mention why it is not possible to have subtotals if you have 4 dimensions?

I have 2 dimensions in my report but I only get subtotals in my 1st dimension.

Does anyone know how the subtotals and totals work when used in an olap report in WRS?

Thanks!

Re: Totals and Subtotals

julierd — Wed, 21 Jul 2010 18:41:09 GMT

Hi Louise,

I haven't been able to reproduce the problem you describe. Which version of WRS are you using?

Thanks,
Julie Message was edited by: julierd

Re: Totals and Subtotals

Madelyn_SAS — Fri, 30 Jul 2010 23:41:39 GMT

Have you seen this note? http://support.sas.com/kb/19/596.html

Totals and Subtotals

athos — Thu, 01 Mar 2012 13:46:47 GMT

Hi there,

I create some olap cube, then open in WRS and then create one report.

In this report i want show some totals of just one measure (Valor Pago em Moeda), in the others colunms do nothing.

I would like know, how can i put totals in just one colunm in the WRS ?

In attach i send one exemple (printscreen), in red the colunms where i want show the totals. But in the colunm (Qtd de Eventos) show no totals.

Is posible do this in WRS?

Thanks.