Traditional web-based reporting with SAS BI tools

Totals and Subtotals

Reply
Occasional Contributor
Posts: 6

Totals and Subtotals

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
SAS Super FREQ
Posts: 384

Re: Totals and Subtotals

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

There is a hot fix available.
Occasional Contributor
Posts: 6

Re: Totals and Subtotals

This Hot Fix is for WRS 4.2 . but currently we using WRS 3.1.
N/A
Posts: 0

Re: Totals and Subtotals

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!
SAS Employee
Posts: 110

Re: Totals and Subtotals

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

Re: Totals and Subtotals

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

Re: Totals and Subtotals

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
Occasional Contributor
Posts: 10

Re: Totals and Subtotals

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!
SAS Employee
Posts: 11

Re: Totals and Subtotals

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
SAS Super FREQ
Posts: 384

Re: Totals and Subtotals

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

Totals and Subtotals

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.

Print_WRS.jpg

Post a Question
Discussion Stats
  • 10 replies
  • 1628 views
  • 0 likes
  • 7 in conversation