Hello Everyone,   I have a pretty simple challenge but I can't find a way to solve it. The scenario is pretty simple, I have 4 Data Queries, one to load Tables and the other 3 are for creating Star Schemas. I would like to schedule the Data Loading Process, in a way that is starts with the Load Tables Script and after it finishes, it executes the 3 other Data Queries one after the other.   I was looking for a way to do it in SAS Management Console but Unfortunately I couldn't.    Can you please help me in this matter ? Thank you so much ... View more

Hello Everyone,   I hope y'all doing very well,   We have a pretty small issue, We Were developing SAS Visual Analytics reports in out TEST and DEV Environments which had full access to the internet. So, as we created our Geographical Map Chart, we didn't face any trouble since the internet Connection was available. Now, as we would like to move the report to our Production Environment, Our security department informed us that they cannot provide full access to the internet in the Production Environment, we explained that the OpenStreetMap is an API that requires Internet Connection, but they asked us to provide the URL that SAS Visual Analytics uses to render the MAP (The URL that Connects to the OpenStreetMap API).   I tried to find it but I couldn't, is there any chance anyone can help ?   Thank you so much in advance ... View more

Hello,   I have a bit of a special need. I would like to calculate the % of a calculated item but while ignoring the filters.   For example I have the following Data   If I want to filter on the European Countries, I would like the % to take the total of value (580) and not 350 (150+200). In other words the % should be like this : Sum(For_Group) Value / Sum (For_All ignoring the filter) Value like this.     Thank you very much  ... View more

Hello,   I was looking for the Limit number of rows that the different objects can show in this link https://support.sas.com/documentation/cdl/en/vaug/69957/HTML/default/viewer.htm#n0r2de9vkep76bn1tjb53x9l43g3.htm    But I didn't understand the following sentence :    If a data source contains more than a million records, queries are blocked for data items whose cardinality is greater than 10,000 unique items in any particular category. Can someone please explain ? Thank you so much ... View more

Hello,   I am facing a pretty strange and weird problem. I have 2 environments DEV and TEST, each of whice installed SAS Visual Anlaytics 7.5 on Windows.   The problem we have is when we created a geoMap Graph in the DEV Environments, it all went well, the graph is complete and all the names of the countries, cities etc..  are well shown. However, in the TEST environment it's not the case, when we add data and show countries as regions it managesto trace it well. but for the countries that are not in data it's just gray.   in other words, in the test environment, the GeoMap graph shows nothing. I checked the StreetLine service on the options panel. in the dev environment when I click Browse next to the StreetLine Service it shows the icon, but it's not the case in the test environment.   PS: the option "Show Map Background" is already checked in the options panel Can anyone please assist us in this matter, thank you very much. ... View more

Hello,   I have a simple and quick question,   I have a cross table with Category/Product on lines and Years on columns and a measure. Can I sort each Product in each category by measure ? In other words for each Category, i want to sort the products by measure. also, can I sort by a measure that is not displayed in the cross table but available in the data panel.   Thank you ... View more