SAS BI Prompts: Gettin’ User Friendly
When creating prompts in SAS Business Intelligence or SAS Enterprise Guide, the value the database or your code uses to populate the field may not be user-friendly. Certainly you want your user community to think you are that cool BI developer tucked away in cubical B7-2. Hey I think you can even get yourself a cool black leather jacket and some boots if you use prompting tips like this one.
BI Prompts from Losers
I’ve talked before about creating cascading prompts and date prompts but those were more of an overall discussion. Here’s an example of something that would be a common way to express the values for a chart output. At your site – everyone may understand the terminology so I’m just using these values as an example. Feel free to leave some comments telling me how you’ve used it.
Building Cool Prompts
In the Prompt Type and Values pane, modify the Formatted (Displayed) Value for the variables. Double-click in the field and add the value you want the user to see. No code changes are need – this only controls what the prompt has in the drop-down (see above). The code still expects to receive the Unformatted value (HBAR or VBAR).
This is one of those little touches that makes your work stand out from others (i.e Rock Star!!). Use it where it makes sense.
Last Tip: Double-check your spelling if you are spell-check-dependent like someone whose post you may be reading. No one wants their output to be a Pig Chat.
Keep your prompts easy to understand to ensure your end users can follow along effortlessly. That’s how you become a Prompt Rockstar!
Never miss a post!
Get the latest BI Notes post in your Inbox when a new post is released! Click here for free subscription. You email address is kept private and you can unsubscribe anytime. Go ahead ... join us!
Attending SESUG 2015?
If you are planning to attend SESUG 2015 in beautiful Savannah, Georgia on Sept 29 then join me for my talk about data visualization "How to be the MacGyver of Data Visualization"! I'll show you some cool ways to visualize data with SAS Visual Analytics as well as some traps to avoid.
Latest posts by Tricia Aanderud (see all)
- SAS Visual Analytics: Get to the Point with a Geo Coordinate Map - August 30, 2015
- SAS VA: Is Location just a Distracting Character in Your Dataviz? - August 24, 2015
- Do You KISS Your Line Charts? - August 5, 2015
- How Not Knowing Pie Charts Makes You a #DataViz Rookie - May 7, 2015
- 6 Tips for Data Visualization from a Floral Designer - March 26, 2015