Hi satir, verry good to hear it works out for you. Thats what its all about here. Greetings ... View more

Dear CWB ?? Technically all of your questions are not directly available in VA. If your questions are enhancements for VA is up to SAS. Thing I wanted to point out is, after working with VA for more than a year, I would never thought about solving any of my issues in this way. Not having any fundamental judgement regarding your way of working, I would like to help finding other ways of reporting your issues or approaching these issues. My experience with VA reporting is to NOT try to copy your existing report but try to create something new and beyond expectation. If you have any interest in ideas trying to solve your issues in a different way of report set-up, please be my guest and we can discus this in person. Greetings  Peter ... View more

Adriane, the full scruipt has been sent to your e-mail. Good luck while implementing it. Greetings. ... View more

Hi Adriana. of course you can get the full macro code. Please give me your e-mail and I will sent it to you. Greetings from Holland. ... View more

Michel, If they are allowed to see each others planning but need their own default to startup, that's not possible by default. (at my knowledge) I did request some time ago an enhancement on the selection bar so that they default on a variable. Same problem with a month selection or so, where you would like the Button Bar to start with the current month. I will ask again if this enhancement can be considered. Greetings  Peter (note:  please use English as default language here) ... View more

hi Michel, You can filter the data by user. Create single logins for each group leader and use this account to create data row filters. Now you have only one report, but they can only see there own data. greetings ... View more

Hi, Avinesh, Than it works the same way, but only you have to define a copied item of the Date to Month format. Sadly I see that if you put year in front of the month, the calculations reset for every year. (I have no idea how to solve this within VA) So I have no direct solution for the cumulation over the years.  (Maybe someone else has a good idea how to solve this) Anyway good luck. Greetings ... View more

Hi avinesh, Just a quick question. Is the data already on month level cumulated or is the data below still on date level. greetings ... View more

Dear avinesh... If all of your data is related to a real date and can be reported in calendar month/days etc you can use the standard YearToDate function First created a cross table with the month and dayOfMonth related to the transaction Date.  (Just an example) Then go to the Kg field in the data tab and right click the mouse for the options to select Create and YearToDate Using Date.  (The transaction date) Just drag in the new variable and thats it. This is from SAS VA 6.3, but I am sure its must be almost the same. Greetings and good luck. ... View more

Manish, At first it should be a Calculated item and not an aggregated measure.  (Was late yesterday...haha) First the formula: So if the "day of the month" of the transaction Date is less than the "day of the month" of today (the 24th "now") then the weight is transfered to the variable kg_form, if not the kg_form gets 0 Here the result. As you can see in this cross table, all data reporting stops at the 24th day of the month. This should work for you in this case. Ones you are used to these kind of calculated items, there are a lot of possibilities. Greetings and good luck.  Peter ... View more

Hi Manish. i Would suggest a different approach. create a new aggregated calculated field where you filter on the day number of the month less than the day number of today. While using the months in the report, it should show the results of each month less than the daynumber of today. if you might need more help, i could set-up a formula sample for you. greetings Peter ... View more

Hi sat_Ir, I will sent the full script to your mail account. Here for all the other interested users. The main function in SAS is as follows, but still needs some scripting to get ir right. %MARCRO Url_get_comp(key, street, zipc, city, country); %LET Url_address="https://maps.googleapis.com/maps/api/geocode/xml?address=&street,+&zipc,+&city,+&country*sensor=false"; %LET Url_address=%sysfunc(TRANSLATE(&URL_address,'&','*')); %PUT &Url_address; FILENAME www url &Url_address; I create a table that contains the non matched addresses and call on the macro by record. The received log/lat are stored in the address table and sent to the VA server. This address table in imported into VA via a data querry and ready for use. Now Change the role of the address field name to Geography and assign the log/lat under custom. This field will now ackt as a geo location field. Greetings and succes. ... View more

I Use a sas script that requests the longitude/latitude off an address string from google maps. This way I get all my long/latitudes and use these in SAS VA. If  you want to solve it this way, I can sent you the related SAS code. It works well for me this way. Requesting the Centre country long/lat also helps with drilling down. (Also for geo area) Greetings. ... View more