topic Re: Thanks for your answer but I do not understand exactly wh... in SAS Visual Analytics

How does SAS Visual Analytics work?

kimo — Thu, 02 Jun 2016 11:51:42 GMT

I am interested in SAS visual analytics. How does this work?

1-you have to build a large table with all variables. All dashboards use this table.

2-you have to build a table for each dashboard.

3-Each dashboard can read from different tables at once

Thank you.

Re: How does sas work?

MichelleHomes — Thu, 02 Jun 2016 09:29:30 GMT

Hi Kimo,

Welcome to the SAS Visual Analytics community. To answer your questions:

1-you have to build a large table with all variables. All dashboards use this table.

Yes

2-you have to build a table for each dashboard.

No you don't have to. You can create multiple dashboards from the 1 table

3-Each dashboard can read from different tables at once

Yes

To get you started using SAS Visual Analytics, you will see a box titled "SAS Visual Analytics Starter Kit" at https://communities.sas.com/t5/SAS-Visual-Analytics/bd-p/sas_va - I suggest going through these links.

Also @ChrisHemedinger posted earlier this week some very SAS Visual Analytics on-demand webinars you may find helpful at

https://communities.sas.com/t5/SAS-Visual-Analytics/Column-Percentage-in-bar/m-p/274082#M4452

Kind Regards,

Michelle

Thanks for your answer but I do not understand exactly wh...

kimo — Thu, 02 Jun 2016 10:33:46 GMT

Thanks for your answer but I do not understand exactly what you mean.

You answer yes to the first question and the third but I think they are contradictory.

If SAS can work each dashboard with several tables at once why build a single large table that is very hard work and not very practical for drill down if the large table is the result of mergers with other tables.

Can it be for performance ?.

Thanks for your attention.

Re: Thanks for your answer but I do not understand exactly wh...

TriciaAanderud — Thu, 02 Jun 2016 10:33:54 GMT

Just to clarify @MichelleHomes comments - you can do it however you like. It is based on your individual report.

In some cases - it works better to have a report/dashboard that is based on a single table. Perhaps you have multiple views of the data - for instance a treemap that shows the products by Batch Number. Then another section that has a map showing where the batch numbers were distributed.

You can also have the data broken into smaller tables if it is more convenient for you or works better for you data.

Re: Thanks for your answer but I do not understand exactly wh...

MichelleHomes — Thu, 02 Jun 2016 12:15:31 GMT

Sorry if my answers appear contradictory and created any confusion.

You can create a large table or multiple tables and load them into memory. If you are replicating the data in the multiple tables, it is obviously taking up additional resources (and may affect performance) which is why you might consider using one large table. Also you may want to use one large table if you want to have interactions within and between your reports so the data can be filtered. The source and target tables must be the same for the filtering to work.

I suggest spending some time reading the documentation, watching videos/webinars/tutorials and perhaps attend SAS Visual Analytics training to gain a solid understanding with your data load/preparation and report creation.

Kind Regards,

Michelle

Re: Thanks for your answer but I do not understand exactly wh...

kimo — Fri, 03 Jun 2016 07:39:20 GMT

Thank you for your time.

Kind Regards,

Re: Thanks for your answer but I do not understand exactly wh...

MichelleHomes — Fri, 03 Jun 2016 07:52:53 GMT

Thank you @kimo. Glad to help.

Kind Regards,

Michelle

Re: Thanks for your answer but I do not understand exactly wh...

kimo — Fri, 03 Jun 2016 08:00:25 GMT

I have a new question: "if you want to have interactions within and between your reports so the data can be filtered. The source and target tables must be the same for the filtering to work."

Is it not possible to put a general filter that filters all tables at once?.

In other words put a filter that interact with all tables but each table serves to calculate indicators.

Re: Thanks for your answer but I do not understand exactly wh...

MichelleHomes — Fri, 03 Jun 2016 08:22:31 GMT

New questions should really be created as a new question so that the thread remains as the original question. Please keep this in mind in future.

Filters are data source specific for the data items involved. If you have multiple tables being used in a report the filters will be applied to only the tables where a filter definition has been applied. Essentially a filter is a where clause on the table.

It isn't possible to have a filter that applies to all the tables "at once". If you require this, it is best to join the tables outside of SAS VA and load the combined table into memory.

Re: Thanks for your answer but I do not understand exactly wh...

kimo — Fri, 03 Jun 2016 08:44:20 GMT

Thank you,

I think I understand. If I make the filter

Country = USA.

If I defined in table1 and table2 the filter. each table is then filtered by the filter USA

It is correct?

Thank you and sorry for the inconvenience.

Re: Thanks for your answer but I do not understand exactly wh...

MichelleHomes — Fri, 03 Jun 2016 09:09:04 GMT

Not exactly...

The filter Country=USA for table1 will only subset the data in table1. Creating a Country=USA on table2 means you are using the Country column from table2 will subset the data in table2 only. You have to create filters per table, even though the column may exist in each table.

Hope this helps.

Re: Thanks for your answer but I do not understand exactly wh...

kimo — Fri, 03 Jun 2016 09:37:02 GMT

Thank you, Is it not possible to create a dropdown menu on the dashboard to apply the filter on each table?

Re: Thanks for your answer but I do not understand exactly wh...

MichelleHomes — Fri, 03 Jun 2016 10:02:59 GMT

As previously stated a filter is a where clause for a specific table. I suggest you read the Working with Filters section in the SAS Visual Analytics User Guide and trying it out in your own environment http://support.sas.com/documentation/cdl/en/vaug/68648/HTML/default/viewer.htm#n0t60h2we10v5pn192cleqptxq71.htm

Kind Regards,

Michelle