In order to import data to LASR, users must have an account on the operating system. This is described here: https://go.documentation.sas.com/doc/en/bicdc/9.4/vaag/n1qzydpsie8xr0n0zddgk8m309l1.htm#p1mhx8msdy8w7dn1bjf3thnpawv6 Unfortunately you will not be able to use an internal metadata user for this.  ... View more

One point I am not clear on here - is the Excel file with the list of bankrupt ID getting loaded into CAS at all? Or is the idea the client has this list, looks at it, and manually goes through the report to filter by the IDs they see inside of this Excel file - so we're trying to find the most efficient way to do that? If the Excel file is not getting loaded to CAS at all, one possibility is to do something like this: - Get the bankrupt IDs in a single comma separated line, like ID1,ID2,ID3, etc - The report needs to have a List Control with a list of all IDs, and a Character List parameter needs to be assigned to the List Control - Generate a URL to the report that includes this parameter. This can be done in the Copy Link dialog for the report: - When ready execute the URL, paste the list of IDs at the end of this URL and execute. One major downside to this approach though is that if the list of IDs is long enough then you may exceed URL length limits (i.e. if the list pushes this past 32K characters) and we cannot get past that.      Otherwise, if the Excel file gets loaded into CAS, could you simply create another List Control where the source is this Excel file and map this datasource to your main datasource with this ID value? The client would then just need to open the report, the List Control would already have all of the bankrupt IDs displayed there, then the client would right-click, select all, and the report would be filtered for the bankrupt IDs? Or - is it possible to do this work outside of Visual Analytics by taking the Excel file and running a job that joins it with the main datasource to create a new datasource that's just for the bankrupt IDs, and then build a report off of that? That way the client would not really need to do anything beyond provide you with the Excel file and then open this report.  ... View more

I think maybe the calculation is a bit flawed here. I assume there are instances where Academic_Student_Status'n = 'Fail' so in addition to PC_ADM_PRS_ID values, you are getting 0 returned for that calculation, and that is getting included in the Distinct count. In other words you are getting a 540 values for PC_ADM_PRS_ID, and then 0, for a total of 541 distinct values. If you are just using this in a single Key Value object, what I think you should probably do instead is just create a single calculated item for the Distinct Count of PC_ADM_PRS_ID: Distinct [_ByGroup_] ('PC_ADM_PRS_ID'n[Formatted]) Add that to the Key Value object, and then add a local filter on the Key Value object for Academic_Student_Status'n In ('Pass','Pass_after_SecondExam'). Meaning - click the Key Value object, click the Filters pane on the right hand side, add this filter.      Otherwise if you already doing some kind of filtering that I'm not seeing - another possibility is if there happens to be a missing value somewhere in the PC_ADM_PRS_ID data item, then Distinct by default includes this in the count.  If that's the case, you might you might be able to account for this in your calculation by adding a second IF statement to check for missing. Something like this (note this is not exact, just freehand typing into this to illustrate the point): Distinct [_ByGroup_] (( IF ( 'Academic_Student_Status'n In ('Pass', 'Pass_after_SecondExam') ) RETURN (IF ('PC_ADM_PRS_ID'n[Formatted] NotMissing)                      RETURN 'PC_ADM_PRS_ID'n[Formatted]                     ELSE 0)) ELSE 0 )) Not sure which VA version you have but there is a property to control this that you or your Administrator can set, and here are the steps for Viya 3.5: 1. Log in to SAS Environment Manager as an Administrator 2. Go to Configuration > All Services > Report Data service 3. Edit the "sas.reportdata.properties" section, and find the property "ignoreMissingValuesInCountDistinct".  4. Turn this one on, save changes, and restart the Report Data service.    For Viya 4 the steps are very similar. For SAS 9.4 this property is in SAS Management Console in the Application Management > SAS Application Infrastructure > Visual Analytics 7.5 properties, and requires a restart of SASServer12_1.  ... View more

I think there's going to be a problem though in how @tijanagilic wants to display this. Getting the calculated value isn't going to be too difficult, but displaying it as another row/column after TEKUCI I don't think is possible. You can only create it as a new measure, which means it will show up as a column next to # (and thus appear twice in the crosstab, once for PRETHODNI and once for TEKUCI) rather than next to TEKUCI as a single column.  I don't know what the column is called that contains both PRETHODNI and TEKUCI so I'm just going to call it Column but what I might recommend doing to get the visual you want is the following: 1. Create two new calculated items to represent the value of # for both PRETHODNI and TEKUCI: If Column IN (PRETHODNI) RETURN # ELSE 0 and If Column IN (TEKUCI) RETURN # ELSE 0   Now you have two new measures, we'll say Prethodni # and Tekuci #.   2. Create a third calculated item for the difference: Prethodni # - Tekuci # 3. In your crosstab, take out Column and #, and instead use the three new measures we created.    If I've misunderstood something though let me know. ... View more

The only way you could achieve something close to this is to use the Custom Graph Builder and stack two bar charts on top of each other, using a Shared Category. I don't think you'll be able to get exactly this though but you might get something acceptable that way? When you create the custom graph, just make sure you turn on Data Labels in each of the Bar Charts: Then you might play around with the Y-Axis or colors or offset the bars to see what might work for you.  ... View more

Could you confirm what version of Visual Analytics you are using? I'm assuming since you said Designer/Viewer then it's either 7.5.x or 8.3.1 maybe.  ... View more

As acordes previously mentioned, you cannot take results from two separate crosstabs and use them in a third crosstab. Visual Analytics does not allow for that.   Rather what you will have to do is create aggregated measures that get you those same results (Counts of 300 and 500, and then Cost of 21k and 43k), and then use those aggregated measures in the crosstab. Without really knowing the data though I cannot say if this will actually be achievable, but this approach will be the only way Visual Analytics will come close to what you need if it can at all.  Alternatively you might be able to achieve this by creating an aggregated datasource with the relevant columns and aggregations. But again without knowing the data, cannot definitively say this will work.  ... View more

Really? What version of Visual Analytics are you using? List Tables have had the Hidden role for years now.  ... View more

Could you not add the calculated item to the Hidden role for the list table? That should allow it to work in the display rule.  ... View more

You should be able to do this by creating a calculated item for your condition first, something like: IF ( ( 'Age'n > 30 ) AND ( 'Salary'n > 5000 ) ) RETURN 'yellow' ELSE ( IF ( ( 'Age'n > 18 ) AND ( 'Salary'n > 1000 ) ) RETURN 'green' ELSE 'red' )   Then use that calculated item in your display rule.  ... View more

@jeffhunta - Report Distribution in SAS Visual Analytics will honor row level security. This only really matters if you choose to include the PDF with the report distribution, and the way it works is that when it comes time to run the scheduled distribution, it will generate the PDF as each intended recipient. If you choose not to include the PDF, then these users will just get an email with a link to the live report, which will force them to authenticate anyway to see it.  Hopefully that helps! ... View more

Unfortunately you cannot assign a parameter to a graph like the time series plot, they can only be set by prompts. If the goal is to show users on the hidden page what date they are looking at, could you do something as simple as adding a list table or a button bar or something like that to the hidden page with your Date column assigned to it? That way when the page is linked, the List Table/Button Bar/whatever should get filtered to the single date coming from the Time Series plot. Or have I misinterpreted what you are trying to do? ... View more