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.
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.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.