there are 5 projects assigned to  leadership team (spm) where they  need to see all projects data where as manager need to see an assigned project (only one )data in sas visual analytics. can we do this in SAS Management console? If yes could you please help me?   ... View more

Hi Team,   Description:   For example  we have 2 reports named as below; 1.List view       and 2. Detailed view   In list view we need to filter based on Release type ,project, release. Here Release type is a calculated column and (Project ,release) are direct columns coming from database . we are using these columns as  global filters and given interactions between them  and it is working fine for  list view.   we need to pass these values to detailed view report to get detailed report of that particular project and release. so, we made a report link from list view to detailed view and we need  pass values for global filters from list view to detailed view.  Because of using calculated column (Release type ),  values are not passing from one view to other view , if we are using only 2 columns directly coming from Database ( i.e Project and Release) we are not facing this issue. If we are trying to include calculated value as global filter we are facing issue   For information we are using drop down list object here.   Please help us whether there is a option to pass value  from one view to other view . if yes  suggest us how to pass calculated value from one view to other view as global filter. ... View more

Hi team,   I am adding another requirement.   I have Planned Start Date as 10 th March 2019 and Planned End Date as 21 th March 2019. current date:20 th March 2019   Result I am getting: Planned Difference in Days - 11 days Remaining days - 1 day(21 st March 2019 - 20 th March 2019)     But 10 th march 2019 - sunday and  16 th march 2019 Saturday and 17 th march 2019 sunday. I want to eliminate Weekends.   Result I need :  No of Business Days = 7 days. Remaining days = 1 day   Remaining days vs Planned : (1 day out of (7 days) as sinlge column to display     Please Help me.   Regards, Pavan. ... View more

Hi team,   I have Start Date as 10 th March 2019 and End Date as 20 th March 2019.   Result I am getting: Difference in Days - 10 days   But 10 th march 2019 - sunday and  16 th march 2019 Saturday and 17 th march 2019 sunday. I want to eliminate Weekends.   Result I need :  No of Business Days = 7 days.   Please Help me.   Regards, Pavan. ... View more

Hi Team,   could you please check the below link and  please say in which versionos SAS VA it is possible?   https://communities.sas.com/t5/SAS-Visual-Analytics/Calculate-a-cumulative-sum-over-a-period-longer-than-1-year/td-p/205716   Regards, Pavan     ... View more

Hi Team,   Here are some defects occuring in SAS VA.Currently i am using SAS Va 7.4   Particularly on graphs: 1.There are a few graphs with no data and there is an “Alert” message. I can  see the error message where i have created a report in a system, whereas it is not shown on other desktops while opening ? 2.On graphs i am using date values on X-Axis, in my system it is showing as 24 OCT 2014 while i am opening same reports on others desktop it is showing as 24 october 2014.   Could you please help us why it is occuring?     ... View more

I am new to SAS Visual analytics. I want to know how to restrict user access for Reports in SAS VA. At Present i am using 7.4 version.   My needs :   1.A login page is compulsory where only authorized user is allowed to login .Based on the user role and access,  Reporting  Dashboard would be accessible   2.The ADM users up to managers will be only able to view the projects part of their assigned Portfolio only. Leadership will be able to view all projects across Portfolios.   Please suggest how i can  apply above changes . ... View more

Hi, I have 2Dates. Start-Date:01-01-2019 End-Date:01-02-2019   I need weekend dates between Start-Date and End-Date as 04-01-2019 11-01-2019 18-01-2019 25-01-2019 01-02-2019   Colud you please Help me   ... View more

We have column with so many dates. But I need Starting value of that particular column. Example: Date Column: 1-02-2019 2-02-2019 3-02-2019 so...on...   I need 1-02-2019. How to achieve this in SAS VA . Note: All the dates are part of category variables. We have a option called First in Aggregated Measures where we can use only Measures, but I have an category value where I need starting value. ... View more