Multiple Interactions with different Data Mappings

[darranm]

Hi all,

When there are two different data sources, of course there has to be some data mapping, but I am wondering as to whether there is an option for the data mappings to vary, depending on what interaction is made.

For example (read BC as bar chart and DS as data source)

BC1 using DS1 > interaction to TABLE1 using DS2

Can I then use another interaction, using these two same data sources

BC2 using DS1 > interaction to TABLE2 using DS2, with different data mappings?

The requirement is for Table1 to pass through a number of filter options, however Table2 should not pass all of these filters, only a few.

Thanks

Darran

[PeterWijers]

Hi Darran,

as described I think it is to difficult.   (Multiple table links on one report page.....)

Could you please make a drawing with some data in it to explain your expectation.

Sometimes its possible to reach your goal solving it in another way.

Greetings  Peter

[darranm]

Hi Peter,

Thanks for the response, I've done a quick mockup of what I am trying to achieve. I'm not sure if its possible within SAS, I guess the workaround is to just add a different dataset for every combination of data mappings I wish to use, although this could become messy..

[RickStyll_SAS · Accepted solution]

It’s not possible in VA 7.3 or older, but that's an interesting use case for sure. I understand how you are trying to set up the multiple interactions with different data mappings between the two data sources. Can you tell us more about what this helps you accomplish? Darran, could you submit this capability as a new idea by clicking here. We might find that other community members need this too.

Rick

[darranm]

Thanks for the confirmation Rick, I admit it is a bit of an odd request, as you would tend to only map the data once if the data sources differ.

There was a requirement to link from one report, to several other sub-reports, passing through different levels of filters.

In this particular case, the main report had a bespoke time-based variable splitting the data, for one subreport we wanted the time variable to be passed through to see a subset of the data. On a second subreport we wanted to see an overall view.

Being able to map the data differently at an object level, would have saved us from replicating the same dataset again, and mapping the data differently at that level instead

I'll submit the idea as you mentioned, thanks again!

Darran

[RickStyll_SAS]

Darran, thank you for the explanation.

Rick