In piping system, the turbulent energy is generated by fluid flow, hence, the process condition as well as pipe geometry has to be considered together for quantitative assessment of flow induced vibration. In most experience cases at practice, the dominant sources of flow induced turbulence are flow discontinuities in the piping system. The dominant energy is concentrated at low frequency below 100 Hz with high level of excitation.
You can find the example - Dynamic Analysis of Water Hammer Loads (HAMMER) in CAESAR II 2013 R1 Application Guide from p.167-179.
CAESAR II performs the dynamic analysis using modal response spectra or time history.
If you needs detail pressure profile, you have to analyze by hydraulic software such as BOSFluids, AFT Impulse, PIPENET, Flowmaster and so on, and calculate the transient loads.
CAESAR II has interfaces to retrieve such transient impulsive loads for dynamic response analysis.
http://www.dynaflow.com/files/documents/Products/Waterhammer1.pdf
http://www.dynaflow.com/files/documents/Products/Waterhammer2.pdf
http://www.sunrise-sys.com/Pipenet%20Newsletter/PipenetNewsletterSummer2008.pdf
http://www.betamachinery.com/services/piping-vibration-and-integrity-assessment/