About PeterWijers

PeterWijers · ‎12-30-2014

Dear all, still missing the filter option on login user to create a conditional grand on the data set. this option would give a huge improvement, as it is already availeble in BI. with this functionality, these kind of problems could be solved in a simpel way. (Development ?) greetings Peter

PeterWijers · ‎12-15-2014

Hi Bill, sorry but no experience with county boundaries, I always use cent coordinates given by Google. So I store the Log/Lat of the customer and center of country. Then the average of the countries by GeoArea is my lat/log for the GeoArea. While assigning these Log/Lat coordinates to Customers/Counties/Countries/Area's, I create the drill-down hierarchies. Anyway I am using 6.3 and will upgrade jan 2015 to 7. Lets see if there are new options.. greetings and good luck.

PeterWijers · ‎12-13-2014

Hi Bill, Please check this previous discussion, maybe it helps you out in a different way. https://communities.sas.com/thread/57062?start=0&tstart=0 You can ask google for the center latitude/longitude by county and use the custom geografics. Greetings Peter

PeterWijers · ‎12-05-2014

Hi Manish/Arun, Same problem for me, that any selection object can not be defaulted and stays on its selection after saving. Beginning this year I already requested this functionality that it should be possible to default a button or range slider with a variable or like in 7.1 parameter. So that the default selection of a buttonbar could be linked to a formula like "month of today", resulting to a default being always the current month. This way you might be able to default the date slider selection to a start/end date being like "today +/- 5 days". Here another request to development...... greetings Peter

PeterWijers · ‎12-05-2014

Hello Teja, Here some explanation regarding the work-around. At first check if you can change/update your data source in a way you get a date instead of a month description. With a date its easy using date formats in your reports that sort well. Work-around is to create a new custom category where the labels are created in a way that alphabetical sorting will lead to the right result. (as mentioned before) So group Jan to 1.Jan Feb to 2.feb etc. Now you have a new variable that contains the values 1.Jan/2.feb/3.mar etc, that can be used in a report or graphic as the right sorting sequence. Other option would be to use 1/2/3/4 etc as period labels to show the number of the month, as often done in financial reporting (Fin.Period) The labels are not perfect, but the sorting is correct now. That's what I called a possible work-around I once used to fix such a problem. In you case I would surely fix the field in the database to match a Date format if possible, or even update to 7.1. Greetings and succes.

PeterWijers · ‎12-03-2014

Hi teja, i am sure it will work in 6.4 greetings. peter

PeterWijers · ‎11-21-2014

Manish, here the code. I used the Between code because in this data source there is also predicted info in the future. IF ( DayOfYear(DatePart(Now())) - DayOfYear(Date) ) Between [inclusive] (0, 7) RETURN 1 ELSE 0

PeterWijers · ‎11-21-2014

Hello Manish, I did set-up the formula in this way and it seems to work today. (Have to test it of cource in the comming days) Please notice that I do use DayOfYear and not DayOfMonth. While testing I found the follwing results where FullFormula is the calculated item as above. Seems to work for today because I already used the filter for this table as below. Please try this one, and we will see the coming days if it works like it does for me with the year selection. Greetings Peter

PeterWijers · ‎11-17-2014

Hi Shawn, again thanks for your reply, Your additional samples show me how to use this functionality as it is now with a parameter link. I am still looking for the functionality as in SAS BI server. So here I can add any hyperlink (no parameter needed) to start-up after clicking on a line in a table or so. I asked the document owner to put the documents in a DMS system so I can show them from there using your provided functionality. (weblink to DMS folder with document name as parameter) So I try to solve this issue now as you reported the solution, but as a work around for the original problem. Anyway I have a request open to SAS development to solve this issue anyway, reported via our local SAS organization. Peter

PeterWijers · ‎11-11-2014

Hi Shawn, thanks for the answer, but thats not what I am looking for. I Would like to have a full weblink to be adressed. we have a table with chemical codes that have a related document (pdf) containing safety decriptions. if i select one of the chemical codes i would like the pdf (described in a table field) to be opened via a new webpage. the weblink of cource now is the network route to the document. could you please check this functionality, because it would solve my problem. in 6.3 it shurely does not yet works like this. greetings, peter

PeterWijers · ‎11-11-2014

Dear all, As discussed in the past, a lot of VA users would like the functionality to link to a web reference (like a pdf or so). The web-link description can be stored in a table and can refer to a related info document or so. I use this web-link a lot with SAS BI but could not find this update in the release documents of VA 7. Even the SAS consultant did not know !! Can anyone inform me if the functionality is available now, and if not how to express the importance of this. Greetings Peter

PeterWijers · ‎10-30-2014

Hi mjaitly Here a screenshot of the calculated_item that detects if the record is within the last three years. If you use this calc.item as a filter for the selction_bar as I did or with a range_slider as you want to do. Succes, Peter

PeterWijers · ‎10-15-2014

Hi Manish, I solved this problem using a new calculated field. If you define the new calculated field result as 1 or 0 depending on the date versus today-7, you can use this field as a filter for the range slider. Just try the list option to be able to select out of the 7 selected days. The list box often works fine when the number of options is rathen small. greetings and good luck.

PeterWijers · ‎10-08-2014

Hi Karthik, I solved the same problem (OTC) while using different alphabetic labels. (VA 6.3) Early / Late etc. In VA 7 this is solved while using custom sorting. greetings Peter

PeterWijers · ‎09-28-2014

maybe if you first drop the origenal lasr table and recreate it under the same name. maybe the import query is stored in the background. while using a registered sas table and importing the data via a data querry, its more easy to control. Greetings Peter

Online Status	Offline
Date Last Visited	‎03-11-2024 08:15 AM