BookmarkSubscribeRSS Feed
Ronny_Dsouza
Obsidian | Level 7

Hi All,

 

Currenty engaged with an Energy firm wherein they do a lot of simulation / analysis using SAS Risk Dimension,  Recently they have bought in the SAS BookRunner Solution,  wherein SAS VA is also provided as part of the solution,

 

Hence the firm nows wants to design a Portal, which will allow its Traders , Risk Operation and Market Risk Team do self service on various different type of scenario analysis such as

1) VAR for Current portfolio at any level

2) VAR for new deal and in current portfolio at any level

3) Historical VAR for current portfolio at any level.

4) HIstorical VAR for new deal and in current portfolio at any level.

 

and a host of it.

 

From my experirence, to do this kind of analysis, i would basically build SAS Stored process and have a front end build using HTML / JavaScript and call these STP, however by going through this approach , i dont think i would be leveraging the power of the LASR server or utilize any of the data loaded in memory.

 

is my above assumption right,  is there something i can do wherein user can load the data in LASR and do all the possible analysis.

 

 

A picture of the analysis is attached for reference.

 

Cheers

Ron


self service VAR calculation.jpg
3 REPLIES 3
TriciaAanderud
Lapis Lazuli | Level 10

Your assumption is correct - a stored process does not make use of the LASR server. If you implement VA using stored processes then VA just becomes an uber fancy web portal.

 

Without knowing more specifics - I don't know why SAS VA could not do scenerio analysis you describe. 


Tricia Aanderud

Twitter: @taanderud - Follow me!

Ronny_Dsouza
Obsidian | Level 7

Hey Tricia,

 

My basic assumption is that for any customized calculation i need to use SAS STP, 

 

Furthermore, if i want to run ad hoc analysis such as VAR, EAR etc using LASR, i would need to use HPA procs which would need to be additionally licensed and  believe this isnt something we can do via calculated measures in SAS VA.

 

Please do let me know if my understanding is wrong.

TriciaAanderud
Lapis Lazuli | Level 10
If I follow you - I think that is true. There may be some workarounds but
it would be on a case-by-case basis.

##- Please type your reply above this line. Simple formatting, no
attachments. -##

Tricia Aanderud

Twitter: @taanderud - Follow me!

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 3 replies
  • 1138 views
  • 0 likes
  • 2 in conversation