In one minute (and 10 seconds, but are you measuring that?) you can add a custom measure (also known as calculated members) to your OLAP cube. Watch this video to create a simple calculation multiplying units * price. Remember that this mechanism is not just used for multiplications, you can
Tag: business intelligence
OLAP cube developers might have noticed that the amount of time required to generate any aggregation (including the NWAY) can negatively impact their productivity. Developers remove the NWAY aggregation (following the sample screens in a prior post) to significantly reduce build time and allow quick modifications to the cube definition.
Drill-through to detail is the ability to right click within a cell of a web report or OLAP viewer and request the detail source records that make up that specific cell's measure. The maximum number of records, by default, is set to 300,000. Feasibly the report user could download all
As I mentioned when creating a user-defined format for Information Maps in a prior post custom or user-defined formats can be created and stored quickly in the default format catalog for all Business Intelligence products within "Lev1\SASApp\SASEnvironment\SASFormats". This is useful for custom sorting, reclassifying or grouping data as well as
Years ago and a seemingly far galaxy away, I wrote about how to modify 9.1.3 to start Enterprise Guide users in a different location for the File folder. By default, the user only can access their personal SAS Temporary File. Why change this? I would prefer to use a central
If you are unable to export BI Dashboard Content the BI Dashboard Logical types was not installed on the system running SAS Management Console. Update this by following these steps Run the software install from the SAS Depot (mine is located at C:\SAS Software Depot\setup.exe) Select ‘Install Additional Software’ Then
Which would you rather do? Click stop (or start) over and over, while waiting in between the services to make sure everything is up and running ... OR ... click one button and go have lunch? Honestly I prefer the lunch option. (And for administrators, the quickest option is always
Functionality to upload files onto the SAS server (from 9.2 on) is available using stored processes and an html input type="file". I introduced this topic last year in my blog post using the SAS Stored Process Developer Guide sample. Of course, it is never as easy as the sample is
Business Problem: The traffic lighting (red/green/yellow) range is different for one group/category than the others but the indicator needs to include all group values. Recommendation: It's all in the data. Here is an example. For the Candy_Sales_Summary data (located in the EG Sample Data folder) there are three groups of
Every six months or so I try to find a recent picture that captures who I am and what I am feeling. Loading this into my various social/online profiles in Twitter, SAS Community, Forums, LinkedIn, corporate internal, Facebook etc then take me a bit of time to implement. Wouldn't it