2 More Great Prophix Tips: Keyboard Shortcuts and Formulas

On Monday, I went over Security and Accessibility in Prophix.  Here are two more time-saving tips for Prophix.

Combining the use of shortcuts and formulas within a template can help you do budgeting and forecasting quickly.  Prophix 11 has “Excel-like” keyboard shortcuts to make your life easier; they allow you to quickly modify different things depending on the module you’re using. The second tip is to use template functions in formulas. These are also “Excel-like” and allow you to create complex calculations quickly and easily.

Prophix Keyboard Shortcuts

microsoft keyboard Prophix

These keyboard shortcuts are meant for Prophix Model Template Designer.

Template Designer Shortcuts

  • Ctrl+B = bold the selection
  • Ctrl+I = italicize the selection
  • Ctrl+U = underline the selection
  • Ctrl+A = select all
  • Shift+Space = highlight the row
  • Ctrl+Space = highlight the column
  • Ctrl+Right = move right to last column of the current block of data (or first column of the next block of data)
  • Ctrl+Left = move left to the first column of the current block of data (or the last column of the next block of data)
  • Ctrl+Up = move up to the first row of the current block of data (or the last row of the next block of data)
  • Ctrl+Down = move down to the last row of the current block of data (or the first row of the next block of data)
  • Alt+M = display MDX for all data views in the template (runtime mode)

Ad-Hoc Analysis

  • F2 = edit current selected cell

Useful Shortcuts

  • F1 = Prophix Help wherever you click on this you can get information of the module you are currently in
  • CTRL+Tab = Switch between Prophix tabs
  • F5 = Refresh Page
  • CTRL+S = To save current page

Administrative Shortcuts

***WARNING***

Do not attempt to alter settings without consulting your Prophix Support Team. These are meant for Administrators and Technical Teams to debug issues you maybe having. Use at your own risk! If you are an Encore Customer, feel free to contact us and we can help you out!

  • Alt+E = Prophix Error Log, if you have ever seen the notice see Prophix log look no further.
  • Alt+D = Prophix Debug mode use this to turn it on and off and check the Prophix Error Log.
  • Alt+T = Alter Debug Tracing setup
  • Alt+U = Alter AMO settings from developer default to custom

*** / WARNING***

Prophix Tips and Tricks: Formulas

Prophix 11 Screenshot Template Designer

Function

Description

And Returns True if all arguments are True
If Tests a logical condition and returns one of the two alternatives
Not Negates a logical value
Or Returns True if at least one argument is True
Concatenate Joins arguments into a single string
Left Returns left so many characters in a string
Right Returns right so many characters in a string
Text Returns a formatted string
Value Returns a number from a string
Len Returns the length of a string
MID Returns a text segment of a character string
HLookUp Finds a value in one row and returns the corresponding value in another
VLookUp Finds a value in one column and returns the corresponding value in another
IsError Returns True if cell holds an error
IsNumber Returns True if cell holds a number
Date Returns the serial number date
Datevalue Returns the serial number date from a string
Day Returns the day of the month
Days360 Returns the number of days between two dates using 360-day year
Hour Returns the hour from 0 to 23
Minute Returns the minute from 0 to 59
Month Returns the month from 1 to 12
Now Returns the current date and time
Second Returns the second from 0 to 59
Time Returns serial number time
Timevalue Returns the serial number time from a string
Today Returns the current date
Weekday Returns the weekday from 1 to 7
Year Returns the year from 1900 to 9999
Db Returns the depreciation using fixed declining balance calculation
Ddb Returns the depreciation using double declining balance calculation
Fv Returns future value of an investment
Ipmt Returns interest payment
Irr Returns internal rate of return
Ispmt Returns interest payment
Mirr Returns internal rate of return
Nper Returns number of payment periods
Npv Returns net present value
Pmt Returns loan payment
Ppmt Returns principal payment
Pv Returns present value
Rate Returns interest rate per period
Sln Returns straight-line depreciation
Syd Returns sum-of-years depreciation
Vdb Returns the depreciation using double declining balance calculation
Abs Returns the absolute value of a value
Acos Returns the inverse cosine
Acosh Returns the inverse hyperbolic cosine
Asin Returns the inverse sine
Asinh Returns the inverse hyperbolic sine
Atan Returns the inverse tangent
Atan2 Returns the inverse tangent
Atanh Returns the inverse hyperbolic tangent
Avg Returns the arithmetic mean of the listed arguments
Ceiling Returns the rounded up value
Combin Returns the number of combinations
Cos Returns the cosine
Cosh Returns the hyperbolic cosine
Degrees Returns the degrees represented by the given radians
Even Returns the number rounded up to the nearest event integer
Exp Returns the value of e raised to the given argument
Fact Returns the factorial of the given value
Floor Returns the value rounded down to the nearest value
Int Returns the value rounded down to nearest integer
Ln Returns the natural logarithm of the value
Log Returns the logarithm to a given base
Log10 Returns the logarithm base 10
Mod Returns the remainder after a division
Odd Returns the value to the nearest odd integer
Pi Returns the pi
Pow Returns the value of one number raised to another number
Product Returns the product of the listed values
Radians Returns the radians from given degrees
Rand Returns a random value
Round Returns the number to a specified number of digits
Rounddown Returns the number rounded down
Roundup Returns the number rounded up
Sign Returns the sign of the number
Sine Returns the sine
Sinh Returns the hyperbolic sine
Sqrt Returns the square root of a number
Sum Returns the sum of the listed values
Sumif Returns the conditional sum of the listed values
SumProduct Returns the sum of the products
Sumsq Returns the sum of the squares
Sumx2my2 Returns the differences of the squares
Sumx2py2 Returns the sum of the sum of the squares
Sumxmy2 Returns the squares of the differences
Tan Returns the tangent
Tanh Returns the hyperbolic tangent
Trunc Returns the number without a fractional part
Avedev Returns average deviation
Average Returns the arithmetic mean
Averagea Returns the arithmetic mean
Binomdist Returns the cumulative beta probability density function
Chidist Returns the chi-squared distribution
Chiinv Returns the inverse of Chidist
Chitest Returns the chi-squared distribution test for independence
Confidence Returns the confidence interval
Correl Returns the correlation between two sets of data
Count Returns the count of the data listed in the arguments
Counta Returns the count of the data listed in the arguments
Countblank Returns the count of the empty cells listed in the arguments
Countif Returns the count of values that meet a specified criteria
Covar Returns covariance
CritBinom Returns the critical value for the cumulative binomial distribution
Devsq Returns the sum of the squares of the mean deviation
Expondist Returns the exponential distribution
Fdist Returns the F probability distribution
Finv Returns the inverse of Fdist
Fisher Returns the Fisher transformation
Fisherinv Returns the inverse of Fisher
Forecast Returns the value forecasted by the linear trend
Gammadist Returns the gamma distribution
Gammainv Returns the inverse of Gammadist
Gammaln Returns the natural logarithm of gamma function
Geomean Returns the geometric mean
Harmean Returns the harmonic mean
Hypgeomdist Returns the hypergeometric distribution
Intercept Returns the Y intercept of the least squares fit line
Kurt Returns the kurtosis of the set of arguments
Large Returns the kth largest value
Loginv Returns the inverse of the Lognormdist
Lognormdist Returns the cumulative lognormal distribution function
Max Returns the largest value among the arguments
Maxa Returns the largest value among the arguments
Median Returns the median value among the arguments
Min Returns the smallest value among the arguments
Mina Returns the smallest value among the arguments
Mode Returns the most frequently occurring value
Negbinomdist Returns the negative binomial distribution
Normdist Returns the normal cumulative distribution
Norminv Returns the inverse of Normdist
Pearson Returns the Pearson product
Percentile Returns the kth percentile of the given values
Percentrank Returns the position of a value in the range of values
Permut Returns the number of permutations
Poisson Returns the Poisson distribution
Prob Returns a probability
Quartile Returns which quarter a value belongs to within an ordered set of data
Rank Returns the position of a value in an ordered list
Rsq Returns the square of the Pearson product moment correlation coefficients
Skew Returns the skewness of a distribution
Slope Returns the slope of the linear regression line
Small Returns the kth smallest value
Standardize Returns the normalized value
Stdev Returns the sample standard deviation
Stdeva Returns the sample standard deviation
Stdevp Returns the population standard deviation
Stdevpa Returns the population standard deviation
Steyx Returns the standard error
Trimmean Returns the mean after removing out-liers
Var Returns the sample variance
Vara Returns the sample variance
Varp Returns the population variance
Varpa Returns the population variance
Weibull Returns the Weibull distribution
Ztest Returns the P-value of a z-test
Get the Full Gartner Magic Quadrant for BI Report

Get the full report on the top BI Vendors.

Get the Report

Get the Gartner Magic Quadrant for BI Report

Get the Report