topic Replicating Excel Pivot table in SAS Web Report Studio in SAS Web Report Studio

Replicating Excel Pivot table in SAS Web Report Studio

JohnT — Tue, 17 Jan 2012 00:57:32 GMT

Hi,

We are trying to remove our Excel based reports and push out all our reports using SAS Web Report Studio.

As our first step, we wish to replicate what we had in Excel, that is a pivot table.

To do this, I've built a cube in DI Studio, and built a report off that in SAS Web Report Studio. My background is using Cognos PowerPlay Transformer, so I'm somewhat comfortable with cubes. I'll try Information Maps next, but I've never really created one before.

I'm largely happy with the report, with the exception of the filtering options. Is there an option to have a couple of variables sitting ontop of a table, click on it, and select what values we want filtered? Or would it be a case of editing the report, putting on the filter and viewing the report? I don't think I want to create a different section for each value in a variable.

Thanks.

Replicating Excel Pivot table in SAS Web Report Studio

twocanbazza — Tue, 17 Jan 2012 19:00:33 GMT

Would a dynamic prompt attached to a filter do what you want, this would however require a Information Map I think.

Not exactly what you describe but I think would produce a filtered report.

Barry

Replicating Excel Pivot table in SAS Web Report Studio

JohnT — Wed, 18 Jan 2012 00:21:39 GMT

Hi Barry,

Dyamic prompts attached to a filter was as close as I could get to finding a solution too. I don't want this, as the majority of times, the user will not know what filters they want applied until they've seen the data.

If the solution to what I want require Information Maps I don't mind using them.

It sounds as though the feature I'm afer doesn't exist.