Hello Jesper, here is the code I sadly forgot to append in the past.  (Anna, sorry for that) greetings and good luck with it. ... View more

Hi satir, Perfect, if you could solve it like that, its the most simple way and works fine if it covers your needs.  (also use it in some situations) I expected a more complex definition/formula and mostly like to solve my problems in the data warehouse, so I also can use the results in other situations. Greetings and good luck. ... View more

Hi satlr, If the transaction sequence number is in the data, you can do it in the designer or even in the prepare data step.  (Just filter seq=1 out) If the transaction sequence number is not already in the data, I have no clue how to solve this. (Maybe someone else....) Greetings,  Peter ... View more

Hi Stanley, You created a direct load of the data into the LASR server, and that is a single load. If you create a "data query" to import the data into the LASR server, you can schedule the update to refresh the data.  (Job scheduler) This might already solve your update/reload problem.  (If a certain update frequency is ok for you) (for me it works fine) Technically you could create SAS script for this. (Never done this by myself) Greetings  Peter ... View more

Hi Satlr, Here again I would advice you to add a variable to you data source being the transaction sequence by item. This way the first transaction sequence is labeled 1 and the second 2 etc. Now you can just filter on the transaction sequence number. I do not see a simple solution within SAS VA, but maybe someone else has an idea. Greetings,  Peter ... View more

Hi satlr, Please consider the next option I often use for these problems. I have created a date table that consist of all calendar dates from 1999 until two years ahead and added several calculated fields.  (with sas base) Here a screen shot of the most common fields. While using this table in the queries and join on the transaction date, I have a scale of fields directly available on any location. If you now mathematically solve your problem creating a variable that is equal for the same situation.  (This data is also used outside of SAS VA and is located in a data warehouse) For example I added a day of the month number that starts on the first Monday in the new financial period and combines the sat/sun into the Friday. This way I have an equal day counter every year that gives me 20/20/25 days scheme.  (Fin.periods  defined as 4/4/5 weeks) One of the profits I gained out of this, is that you only have to create the field once and can reuse it all the time without any additional effort. (Anyway, if a definition would change, you only have to change it once in this table, and all of your graphics will follow automatically) Maybe this is an idea to use. Greetings and a lot of success solving your problem. Peter ... View more

Hi Anna, I agree with you regarding the security issue. (Never thought about it in this way) Please sent me the last email address so I can sent him the code. I will try to upload the code as mentioned by you at a later moment. Greetings Peter. ... View more

Hi Satir, I did solve a likewise issue in the past, but I had to use a structured table that translates days into selectable keys. (non VA) So while using this special table in the querry of VA, you create these options to be selectable in VA. I wlll check if it might be possible in VA directly, assuming you alsways want to see the cumulated rusults of that week until the selected day. I have holiday now, but will be back on this within 1-2 weeks. Greetings  Peter ... View more

hello bhagia, I did sent the full code to you just now. Good luck with it and greetings. Peter ... View more

Hi Angeliquec, I only use one source so there no answer. I use a usergroup to assign the table read/write rights and its easy to control. I do not understand why you would like to have the tables in multiple metadata folders if this way of easy permission assigning works well. So no ACT's  but just Usergroups with read rights, and assigning users to them. If you need more information, be my guest. Greetings  Peter ... View more

Hi Sat_Ir, If you have a dataset with a date  (Invoice date) you can use the week number function   (VA 6.3) Create a new Calculated Item and use the formula  week number(Invoice date). Now you get the week number of the Invoice date.  Do not forget to switch the numeric field to a Category before you start using it. Ones it is a category, you can use it as a label in graphs or tables. Sure this will work. Otherwise this is the mathematical function week_nr= INT(1+int((date+(3-mod(weekday(date)+5,7))-intnx('year',date+(3-mod(weekday(date)+5,7)),0))/7)); Greetings ... View more

Michelle, Had a talk with Mary Clarke and Sheila Crosby, and also mentioned this problem again. Lets see what's there in 7.1 greetings ... View more