About daha

daha · ‎02-08-2016

Is it a Linux setup? I've had the same issue on our SAS Setup. After several hours og investigation, conversations with SAS consultants, their support was able to help me. It seems to be an error during the setup of the SAS Enviroment. In the config file you need to deifne how much memory the LASR server is allowed to use. This was fixed by help from SAS Support, as I'm not so familiar with changing parameter on the Linux side in the enviroment.

daha · ‎01-08-2016

Hi Jesper, Not directly related to your topic but just some additional infomation which might be nice for you to know. Our SAS Consultants has reached out to us regarding the upgrade fra 7.1 to 7.3. We had a phone-meeting and in the end we decided not to upgrade as the changes were not significant when it comes to functionality in SAS VA. We have been aware of the HTML5 transition which should give a better user-experience speaking of performance, with all respect to JAVA 🙂 and also a few new features on the mobile-BI App. Likewise we were afraid to run into such "issues" as you have ran into, as the 7.3 was not a need-to-have version but more a nice-to-have although it has brought some bug-fixes which we have learned to live with as far as the following might take... Our SAS Consultant told us that a new version is about to be released between Q1 and Q2 - 2016, but more likely it will be in the end of Q2, start of Q3 - 2016. Here the exploration and design (report) parts will be combined, theres was a presentation about this on SAS Forum las year, and we are aiming for this release. Hopefully the export-issue will be solved here. /Dado Hajric Vi sidder også i lille Danmark 🙂

daha · ‎01-08-2016

Hi Arpan, What happens if you try to change your outer boundaries (_Inferred_) in the function to _Year_? How is your Rev. in INR (Cr.) built up in the data-set? /Regards

daha · ‎01-07-2016

@Sam_SAS, because I would like to see how the category behaves (in this case, the segments) in growth whether the kWh has increased or decreased and how much from '11->'15 in lets say segment FAM_C.

daha · ‎01-06-2016

@Sam_SAS, Got the result. It's working 🙂 Although I had to do it in my backend. One additional question. On my x-axis I had years in the previous graph, what if I ie. used segments, and want the growth function to represent the growth from '11-'15 based on the segments. I see that I don't have any variable representing years, see below. Any ideas? I would like the results to appear like on the graph below. OBS! Please don't take care about the values in the graph below as they are wrong.

daha · ‎01-06-2016

@Sam_SAS, I just think this is a very basic thing. It's an regular average calculation saying expressing sum of kWh devided by sum of customers. On the other hand this gives me the experience of SAS VA not having the ability to create growth calculations on aggregated variables.

daha · ‎01-05-2016

@Sam_SAS, thank you for that. You are right, I could replicate the numbers as my kWh is represented for each day in the dataset. Applying the kWh to the graph resulted in the average kWh pr. day pr. year which matched the growth function of the red-line and the numbers were correct. But I'm still interested in showing the kWh average pr. year (NOT average pr. day pr year) and add the growth line for these years. I'm missing something, but can't figure out what.

daha · ‎01-05-2016

Hi Teja, Yes, there is not much to share else than it's a unique ID for each customer. For example LL000001, LL000002....etc.. It's just to use an ID to identify my customers.

daha · ‎01-05-2016

@Sam_SAS, That also might seem to be the issue. The 'kWh Avg. pr. Year' is an aggregated value. This value is a subset of (Sum _ByGroup_ (kWh) / SX Bruger-id), as you can see on the illustration below. I needed this aggregated variable as I want to calculate the average kWh usage pr. year. The SX-Bruger-ID is just a uniqe ID for each customer/user. This prevents me from right clicking on 'kWh Avg pr. Year' and creating the growth. Any ideas? If I assign the "kWh" measure to the graph and set the aggregation to Average, then I',m getting the daily average pr. year, as my lowest level of kWh data is pr. day, but I want it presented as an average for the year. And to make it clear, no it doesn't change any numbers on the red growth line.

daha · ‎01-04-2016

@Sam_SAS, that didn't change much, as you can se below.

daha · ‎01-04-2016

Hi, A new release of SAS VA where Exploration and Designer are combined is expected in Q2. At least thats what our SAS Consultant has informed us.

daha · ‎01-04-2016

Hi Teja, Thanks for your suggestion. I found the derived function 'Year to Date Growth' shortly after I posted my question. So now it looks like the picture below. (Be aware, it's new kWh Avg pr. Year values as the values in the thread-start were wrong, minor detail). With the growth funtion: But something seems to be wrong. If I manually calculate the growth: '11-'12: [(5291-5359)/5359] = -1.2% '12-'13: [(5035-5291)/5291] = -4.8% '13-'14: [(4802-5035)/5035] = -4.6% '14-'15: [(4335-4802)/4802] = -9.7% I get these values from year to year. They somehow seem to approximate the values on the red-line graph with a little deviation, although the growth from '14-'15 is totally deviated by ~ -7%?

daha · ‎12-21-2015

Hi, I'm trying to derive an aggregated percent-differential value from the picture below, for each year. I've done it in Excle, but would like to do it in SAS VA as well. What I'm calculating is the differential kiloWattHours [kWh] from 2011-2014. I'm on the track that I have to use the Parallel period function, but I'm not sure. I Hope the picture explains itself.

daha · ‎11-17-2015

Hi TejaSurapaneni, Thanks for your answer. But the given list of files that I can modify doesn't make the issue easier to solve 🙂 And I'm not familiar with step 3 and 4. Is this supposed to be done by our SAS consultant?

daha · ‎11-17-2015

I would still like to know where, as I have access to the server-side as well.

Online Status	Offline
Date Last Visited	‎02-09-2016 09:42 AM

Re: Upload dataset to LASR/Error: insufficient memory.

Re: Export to Excel in SAS Visual Analytics Modern look (HTML5)

Re: Parallel period percent function not working as expected

Re: Parallel period - How to solve this?

Re: Parallel period - How to solve this?

Re: Parallel period - How to solve this?

Re: Parallel period - How to solve this?

Re: Parallel period - How to solve this?

Re: Parallel period - How to solve this?

Re: Parallel period - How to solve this?

Re: Parallel period - How to solve this?

Re: Upload dataset to LASR/Error: insufficient memory.

Re: Upload dataset to LASR/Error: insufficient memory.

Re: Export to Excel in SAS Visual Analytics Modern look (HTML5)

Re: Parallel period percent function not working as expected

Re: Parallel period - How to solve this?

Re: Parallel period - How to solve this?

Re: Parallel period - How to solve this?

Re: Parallel period - How to solve this?

Re: Parallel period - How to solve this?

Re: Parallel period - How to solve this?

Re: Parallel period - How to solve this?

Re: reset all filters in VA Report

Re: Parallel period - How to solve this?

Parallel period - How to solve this?

Re: Auto save

Re: Auto save