Hi, To get the feel what you want, you have to add one "list object" in obove snapshot of the report. May be this solution could help you :- 1) Create a calculated Item "Month Number" as" Month(DatePart(calldate))" 2) Create another calculated Item "Present Month Indicator" as :-                                                             IF ( Month Number = Month(DatePart(Now())) )                                                                      RETURN 1                                                                       ELSE 0 3) Create a Custom Category "Month Name" based on "Month Number" created in step 1 and create 12 labels as jan, feb, mar etc and assign the corresponding values from "Month Number" distinct Values. Now in the design part of the report :- a) Add list object and assign the category as "Month Name" that we created in step 3 and apply a advanced filter as "present month indicator <> 0". b) Uncheck the "Required" in the properties of list object. c) Now simply give the interaction from "List object" ----> "Drop Down List" and from "Drop Down List"----> "Treemap". So whenever the month changes, that particular month will be displayed in the list and the drop down list will contain the "calldate" for the same month. Now if user wants to pick from other month, they can just uncheck the month name in the "List object". Hope so, this helps you if I understood your requirement correctly. Regards, Abhishek ... View more

Hi Niz, I think so it is possible to attain the above requirement once you make all these 12 measures(months) into one category may be named as "Months" which can be achived at the stage of data preparation. Thanks Abhishek ... View more

Hi Nikhil, We can rename the desired dataset in LASR using the SAS management console by locating the folder in which it resides. Thanks Abhishek ... View more

Hi Niz, To attain the obove requirement, you have to create a calculated Item and them custom category on calculated item. 1. Create a calculated Item:-                     IF ( Month(Time) > Month(DatePart(Now())) )                     RETURN 1                     ELSE 0           where "Time" is the date measure. Let us say the name of this calculated item is "Calculated Item (1)" 2. Create a Custom Category based on the calculated Item that we have created above "Calculated Item (1)", let us name it "Custom Category 1" :-           Create label "Actual" with value of "0.00" and "Projected" with value of "1.00". Now you can use the created "Custom Category 1" in crosstab as column role to attain the required report. Hope this helps you. Regards, Abhishek ... View more

Hi Rahul, If you had followed all the steps as indicated in the installation guide , the link should work perfectly. Any how if the installation and configuration are correct, just be sure that you are using the correct link to open the hub (http://VA-host.example.com/ SASVisualAnalyticsHub) where VA-host is name of your server and example.com is the domain name. Even though it dosent work try to reinstall the fresh copy. I would rather suggest you to first install as the first step and then configure the VA as the second step. If you want to reinstall, you have to perform the following step before reinstalling:- 1) Stop all the SAS services 2) Remove the SAS Folders(Installation and configuration) from the system 3) Remove System registry of the SAS Software 4) Remove System Registry of the SAS Services 5) Restart the server and then try to install fresh copy of SAS Software Regards, Abhishek ... View more

Hi Bill, The purged data role has to be unchecked by administrator in order to use the report offline. Also if you are unrestricted user, automatically the data will be purged once you close the report and offline report will not work. SAS(R) 9.4 Intelligence Platform: Middle-Tier Administration Guide, Second Edition Thanks, Abhishek ... View more

Hi , Could you please provide some screen shot, which can make us to understand more clearly what specifically you are trying to achieve. Thanks Abhishek ... View more

Hi gyambqt, You can plot the time varaible in time series as well as bar chart which I had tried.May be there will be lot of other charts which can be used.. If you are getting issue while plotting the chart, try using "New Calculated Item" and use "Hour" or "Time Part" from "Date and Time Part" in operator section to get your variable in the appropriate format. Thanks, Abhishek ... View more

Thanks Ted for prompt reply. Hopefully this functionality would be added in future release. ... View more