Eeeeek!!! Your stored process failed. It worked when in EG – how could this disaster have happened? If you check the log, you may see an error similar to the following about the Libname not being assigned. The library where you stored the data, in this case, MYLIB was either available to SAS EG but not widely known to the SAS BI system or maybe it has a different name in the metadata. To move forward, you need to add a LIBNAME statement that describes where the metadata is located to the stored process. So you would add the following to the code: LIBNAME name meta liburi=”SASLIBRARY?@name=’metadata_name‘ “; You have seen LIBNAME statements before – but wow this one has some extra goodies. My Enchanted Mouse Tricks You may be wondering how I knew what to assign the values – clearly it must be some kind of BI white magic. Yes, using my enchanted mouse in EG, I pointed-and-clicked my way to the answer. In the Server List, I located the dataset being used (SALES_CANDY_HISTORY) and noted the library name, which is Candy. If you review the Candy library properties, you can see some information about the library, where it is stored […]
Tag: Building Business Intelligence
Web Report Studio: Who stole my pie (chart)?
Ok – I”ll just say it. I hate pie charts. If there are more than a few categories – then the user has to interpret the ranking order, it slows them down, and they may loose interest in the report that you so lovingly prepared. Maybe you say – “Tricia, add the numbers! Geez – you’re so dramatic!” Then I will calmly reply to your dramatic outburst, if I want to have numbers – then why not just provide a data table? Let’s look at some examples so I can use the power of screen captures to sway you to my way of thinking. 30-Second Test Consider the following beautiful pie chart from Web Report Studio – you have 30 seconds to decide the product had the largest sales. It will take 30 seconds because you have to determine which slice actually is the largest (and there are two competitors) and then correlate the slice color to the product name in the legend. Go ahead, I’ll wait. Ok – let’s try the method of adding the numbers. Note that this beauty contest winner is getting cluttered. To make room for the numbers, the chart is getting smaller. I could use percentages to make the […]
What has 435 pages, 500+ screen caps, and is ready for SAS Press today?
We can’t adequately convey how exciting and satisfying it is to get the Building BI With SAS book to this final stage! After awaiting feedback from reviewers, implementing the majority of suggested changes, and retaking all of the 500+ images, the CD is burned and ready for drop off. SAS Press will now take all of this content, run through editorial staff, create an index, finalize the artwork, and create a printable book. This phase typically takes around 90 days, so the likely available date for purchase is January 2012. Fun Book Statistics Content Chapters: 10 MS Word Page count: 435 TIF Files (screen caps): 536 Space on SAS Press CD: 678MB Longest chapter: Prompt Framework (60 pages) Chapter with most screen captures: Web Report Studio (94) Chapter that took longest to write: Introduction – rewritten 3 times! 🙂 Chapter that took least time to write: Introduction (the first time!) Reviewer comments: Avg 12 per chapter Time Line Book Proposed – Dec 2010 Contract written for book – Jan 2011 Final draft due date – Jan 2012 – Delivered 4 months ahead of schedule Total Days writing: 244 Book available: Jan 2012 (maybe even the first week!) Reviewer Comments Three […]
Web Report Studio: Chops off the columns and rows …
By default, Web Report Studio only shows the first 12 columns and 40 rows of a report. You can change the default in the Table Properties to allow as many columns or rows to display as desired.
Here is a before and after shot of the changes:
Ugly Web Report Studio Reports?
If you only use the default settings when building Web Report Studio report, the results may not be very attractive. For instance in the following report the graphs are different sizes and the spacing between them is awkward.
To change the image s…
Enterprise Guide welcome screen
The first screen you see when opening SAS Enterprise Guide is the Welcome to SAS Enterprise Guide window, allowing you to open a previously open project (1), create a new project (2), or (3) open the supplied Tutorial. I typically open Enterprise Guide to create a set of code. For some reason, all of these years I have clicked on the New Project button and then from the Enterprise Guide menu selected File->New->Program. I think that since Enterprise Guide is always 1st a Project file, rather than a .sas program file that this was the order I needed to go. Of course, there is a better way. If I select link for New SAS Program in the New Area (numbered 2 in the screenshot) it not only opens a new SAS program node, it creates it within a SAS Enterprise Guide project. Doh! What was I thinking all of these years. Made me laugh out loud to realize the lost productivity. Is anyone else out there making the same mistake?
Web Report Studio: Yellow Icons with !
When you start a new report in Web Report Studio, you may notice that yellow icons with an exclamation point (!) appear in the work area. This happens when you have not added any data to the objects. In the example below, the first capture shows th…
Info Map: I want an Average not a Sum!
In Information Map Studio, you can easily set the default measure for a data item in the Properties area.
(1) Use the Default aggregate function drop-down to select the default. When you set this item to AVERAGE, the data item defaults to Average t…